BookmarkSubscribeRSS Feed
Mahesh_124
Calcite | Level 5

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

1 REPLY 1
SASKiwi
PROC Star

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 816 views
  • 1 like
  • 2 in conversation