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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 777 views
  • 1 like
  • 2 in conversation