Desktop

Ask something
Discussion Locked

Can SQL Server define a DB2 table?

0 helpful
3 replies

by jay_stobbe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can I define a DB2 table or link to a DB2 table using SQL Server? If so, how?

3 replies

by ncseric

Assuming you have the appropriate DB2 drivers, you can defined a Linked Server to your SQL Server. Go to Enterprise Manager, open your database server, and then open the Security folder. You can define a new Linked Server there. The dialog allows for all types of databases, including ODBC-based connections. Once the server is linked, you should be able to use it within SQL Server.

This discussion is closed to new replies.