Execute Query using DB2

• sumit.joshij

  Ten Centuries

  Points: 1040

  More actions

  July 20, 2010 at 6:49 am

  #237807

  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.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  July 20, 2010 at 7:43 am

  #1195518

  What was the query and what was the error?

  Are you using DB2 syntax or T-SQL syntax?

  ---