jde_x_pert
Well Known Member
Has anyone been able to update a SQL table when running a batch job on the AS/400? I have created the link to the SQL server and can update it when running a OneWorld table conversion program locally, but when I submit it, it does not work.
Also, what alternatives do I have to try and create a seamless interface between the AS/400 and SQL server. (SQL2008). I can do this in SSIS, but it seems like I would have to kick off the job every 5 seconds to make it almost real time. The interface will update tables both ways.
Thanks,
Also, what alternatives do I have to try and create a seamless interface between the AS/400 and SQL server. (SQL2008). I can do this in SSIS, but it seems like I would have to kick off the job every 5 seconds to make it almost real time. The interface will update tables both ways.
Thanks,