We are looking to be able to transfer files from a server running Microsoft SQL Server 7.0 to our AS/400, using programs launched from the AS/400...is this possible, are there any products you know of to facilitate this?
I'm assuming you need to be able to write arow to ms SQL after it was written to AS/400 database.
Several options:
1. Use Java on the AS/400 and write to ms SQL using native jdbc driver.
2. Use a product such as IBM's data joiner that will let you perform drda over different databases.
3. Use a replication product such as symbiator from vision solution.
4. Use program on the pc that will use ODBC to monitor requested files for new rows and then write the new rows to ms SQL.
This was first published in November 2001