Writing a record from the AS400 to a MS SQL 2000 table

[joshs1100]

Is it possible to write a record to a table on a MS SQL 2000 server from the AS400 using ODBC, or some other means of connection?

Thanks!

 

[jmanj]

Yes if you mean tables from AS400 to table in SQL server and vice versa. You need ODBC on both platforms. We use SQR language to do the job.

 

[Mercury2]

See this link

http://www.dbazine.com/db2/db2-mfarticles/mullins-drda

It should help you understand the DRDA concept.

 

[joshs1100]

How do you create the odbc connection to the target MS SQL database from the AS400?

 

[as400pro]

You can use Java and a JDBC driver, here are some links. You may have to register (free) to read the first one.

Accessing Microsoft SQL Server from the iSeries

http://www.mcpressonline.com/mc?1@38.Ewf9aUGh92D.2151@.6ae6296d

Accessing Data on Microsoft SQL Server from OS/400

http://www-912.ibm.com/s_dir/slkbase.NSF/0/5a3856efecb7f19f8625672b006cee76?OpenDocument

T. Bishop

http://www.as400pro.com