update tables on MS SQL server from iseries?

[mapperkids]

Hi,

What is the best way to update the tables on SQL server 2005 from iSeries.

Ideally, after certain fields updates on the as400 tables, then will update the fields on the SQL tables as well.

Any suggestion?

Thanks!

[Mercury]

Re: update tables on MS SQL server from iseries?

You'ld access SQL Server in two ways

• SQL Call Level Interface (never tested)
• JDBC driver could be another option