Update a SQL table from an AS/400 program

I am looking for a way to update a SQL table from an AS/400 program. We have already sent data to the AS/400 and would like to push it back to SQL. We currently pull data on a schedule, but are looking for a w开发者_StackOverflow中文版ay to get instant gratificiation by updating the table directly.

If I understand what you mean, you have at least 2 tools for executing a SQL statement in a DB2 for AS/400:

• "Run SQL script" from iSeries Navigator GUI
• STRSQL command inside a 5250 emulator

I assume you like to push as400 db2 data to MS SQL server, I would use java jdbc or java ORM tool.