Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Can I update DB2 tables?

Author  Topic 

cs_bhimavarapu
Starting Member

23 Posts

Posted - 2002-08-23 : 10:18:50
I am working on linked servers, OPENQUERY for a while and doing data extracts from DB2 into SQL Server database. Now we have a requirement in a different project, in which, I need to update the DB2 tables based on the data in SQL Server database. My question now is, Is there a simpler way that we can update DB2 tables from SQL Server rightaway, instead of FTPing data to DB2 and doing updations to DB2 tables?

Thanks!

   

- Advertisement -