DATA Step, Macro, Functions and more

Unable to connect Db2 using openquery

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.




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 ".
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
  • 1 like
  • 2 in conversation