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?
 
Kevin3NFConnect With a Mentor Commented:
You need to use OPENQUERY or set the DB2 database up as a linked server befoer you can query it
0
All Courses

From novice to tech pro — start learning today.