Does anyone have experience in updating SQL2000 from AS400/Db2?

We have data on our AS400 that gets updated only about 4 times a day. basically a production schedule system. We do not have journaling on the tables so "replication" is out, but once the data has been changed I need to push the data to my SQL server in as real time as I can. I am trying to limit the overhead of querying the AS400 repeatedly when there is no change. So in essence, does anyone know how to set up ODBC and a "linked server" on an AS400/Db2 database to an SQL2000 Database? I have already done it the other way around and it wasn't too difficult.

Thanks!
David Hay

Not sure if this helps. But I am not good at that. Just managed to find something to help you out.

Linking AS/400 with SQL

Hope that helps
Cheers!

_________________________
- Vijay G
Strive for Perfection

Thanks happy, but I have that already, I'm looking to go the other way, FROM the AS400 to SQLServer. I appreciate the thought though.

David

You should look for an AS400 forum... WE have an AS400 here and anything we need to move from the 400 to SQL is done through a SQL DTS package. I know of no way for the AS400 to talk to SQL Server on it's own.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Here is what I found:

http://www-919.ibm.com/developer/db2...c/data_acc.pdf