08-15-2017 09:34 AM
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.
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".
444 disconnect from odbc;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
08-15-2017 10:32 PM
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"?