Unable to connect Db2 using openquery

Mahesh_124 — Tue, 15 Aug 2017 13:34:48 GMT

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):

Re: Unable to connect Db2 using openquery

SASKiwi — Wed, 16 Aug 2017 02:32:11 GMT

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"?

topic Re: Unable to connect Db2 using openquery in SAS Programming

Unable to connect Db2 using openquery

Re: Unable to connect Db2 using openquery