Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data Transfer from SQL Server to AS400 Expand / Collapse
Posted Friday, October 15, 2010 2:04 PM


Group: General Forum Members
Last Login: Friday, March 9, 2012 4:17 AM
Points: 12, Visits: 113
We have a requirement to transfer data from SQL tables (may be derived data) to AS400. With this SQL server also need to get intimation from AS400 as it has processed all records and updated in their system. If any issue is there AS400 need to be sent it back for that particular errornous row.
This interface will be running in real time as a scheduled job hence SQL server need this information so that when next time job will run it should not send data which is already being sent earlier and proceesed successfully by AS400. Basically we need flagging.

Has anyone done a similar kind of approach earlier?
Can we update AS400 data (I am not sure of AS400 structure) from SQL?

Please assist

Tahnk You
Post #1005570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse