pull from DB2 using ODBC

I have a ODBC source for DB2 setup and working.

What I am not sure of is how to make a connection to DB2 thru SQLServer 2005 with a query.

Lets say my query is:

SELECT *
FROM somedb.sometable
WHERE somecolumn = 'a'

How would I get this to run using the ODBC connect?
whargraAsked:
Who is Participating?
 
Kevin HillSr. SQL Server DBACommented:
You need to use OPENQUERY or set the DB2 database up as a linked server befoer you can query it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.