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
 Transact-SQL (2000)
 SQL pulling from DB2

Author  Topic 

rohans
Posting Yak Master

194 Posts

Posted - 2004-04-23 : 08:30:51
I would like to pull some information from my AS/400 (DB2) using an ODBC connection. I have never done anything like this before and seeking some assistance on the issue. I also would like to know if using an ODBC connection is the best method of doing it.

I also require keeping the table in SQL consistent with the information being pulled from the AS/400, similar to replication.

All help appreciated.

X002548
Not Just a Number

15586 Posts

Posted - 2004-04-23 : 09:43:19
On what basis?

Changes only?

Full replace of a table?

Did you try DTS?

Linked Server?



Brett

8-)
Go to Top of Page
   

- Advertisement -