Execute Query using DB2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Execute Query using DB2

Execute Query using DB2

Rate Topic

Display Mode

Topic Options

Author

Message

sumit.joshij

Posted Tuesday, July 20, 2010 6:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:06 AM
Points: 47, Visits: 266

I am connecting to the IBM DB 2 using the OLEDB 2 provider.

I am not able to execute the sql query in it.
any body can help me.
I have to transfer the data from Mainframe DB 2 to Sql server

For sql server I am using 2005 version.

Post #955504

Phil Parkin

Posted Tuesday, July 20, 2010 7:43 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:12 AM
Points: 4,226, Visits: 9,458

What was the query and what was the error?

Are you using DB2 syntax or T-SQL syntax?

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #955563

« Prev Topic | Next Topic »

Permissions