开发者

Update a SQL table from an AS/400 program

开发者 https://www.devze.com 2023-02-16 11:34 出处:网络
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 lookin

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消