OPENROWSET on DB2

• b-167654

  SSC Veteran

  Points: 245

  More actions

  August 18, 2004 at 2:34 pm

  #152263

  I trying to use following OPENROWSET to select a bunch of rows from a DB2 table:

  SELECT a.*

  FROM OPENROWSET('IBMDADB2','xxx.xxx.xxx.xx,50000';'myuserid';'mypassword',

  'SELECT * FROM mycatalog.mySchema.T_LastNames') AS a

  This is the error message I am getting..

  OLE DB provider 'IBMDADB2' reported an error.

  [OLE/DB provider returned message: CLI0124E Invalid argument value. SQLSTATE=HY009]

  OLE DB error trace [OLE/DB Provider 'IBMDADB2' IDBInitialize::Initialize returned 0x80004005: ].

  Am I missing something here...I am new to this... could somebody point me in the right direction. Thanks

• Ralph Mallamace

  SSC Eights!

  Points: 926

  More actions

  August 19, 2004 at 4:13 am

  #519724

  I thought the syntax was not:

  SELECT a.*

  FROM OPENROWSET('IBMDADB2','xxx.xxx.xxx.xx,50000';'myuserid';'mypassword',

  'SELECT * FROM mycatalog.mySchema.T_LastNames') AS a

  but more along the lines of:

  SELECT a.*

  FROM OPENROWSET(

                  'IBMDADB2',

                  'address=xxx.xxx.xxx.xx,50000;uid=myuserid;pwd=mypassword',

                  'SELECT * FROM mycatalog.mySchema.T_LastNames'

                 ) AS a

  But thats just guessing from looking at other doco and that doco I'm looking at is using the SQLolddb

  provider

   

  Good luck

• A. Novick

  SSC Veteran

  Points: 221

  More actions

  August 19, 2004 at 5:32 am

  #519732

  I've found that DB2 (on a 400) is case sensitive in some places.  In particular, I suggest that you capitolize the library.schema.table name, which you have in lower case. 

   

• Rhk Alluri

  SSC Journeyman

  Points: 79

  More actions

  June 1, 2006 at 9:43 am

  #641220

  Hi, 

   Can you please send a sample of code for Connecting to DB2 using OPENROWSET.

  Thanks

  Buddy