DATA Step, Macro, Functions and more

Unable to connect Db2 using openquery

Reply
Occasional Contributor
Posts: 8

Unable to connect Db2 using openquery

Hi ,

 

I am tryng extract data from db2 by using openquery in PTF application .But its getting below error(sharing log window).

i'm not able to extract data.Please help on this.

 

 

Thanks,

Mahesh T.

 

ERROR: CLI describe error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot get the column
information from OLE DB provider "IBMDADB2" for linked server "TOMEBBS". :
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "IBMDADB2" for linked
server "TOMEBBS" returned message "[DB2/LINUX] SQL0104N An unexpected token "db2inst1"
was found following "ount(*) as countFROM". Expected tokens may include: "FROM".
SQLSTATE=42601 ".
443
444 disconnect from odbc;
445 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):

Super User
Posts: 3,927

Re: Unable to connect Db2 using openquery

Posted in reply to Mahesh_124

Please post your full SAS log including the source code. Looks like you are initially querying an SQL Server database that is linked to a DB2 database. One clue: "ount(*) as countFROM" perhaps should be "count(*) as countFROM"?

Ask a Question
Discussion stats
  • 1 reply
  • 128 views
  • 1 like
  • 2 in conversation