Facing problem while extracting the data from table SAS 9.2.

Reply
N/A
Posts: 1

Facing problem while extracting the data from table SAS 9.2.

Hi,

Recently we have upgraded SAS from 9.1.3 version SAS 9.2. when I have run the below query in QMF or Query Analyzer, its running fine, but when I run the same query in SAS 9.2 in OS/390 I am facing the below error. It seems to be very strange for us. can any one please help on this.

libname xget db2 ssid=dbps schema=sysibm;

proc sql;

   create table step1 as

  select *

  from xget.SYSINDEXEC

;

quit;

will produce the error,

DB2 WARNING:                                                              

RESULT OF SQL STATEMENT:                                                  

DSN00238W SQLDA INCLUDES 50 SQLVAR ENTRIES, BUT 118 SQLVAR ENTRIES ARE    

             NEEDED FOR 59 COLUMNS BECAUSE AT LEAST ONE OF THE COLUMNS    

             BEING DESCRIBED IS A LOB                                     

A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:              

          ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0                 

          SQLCODE: 238 SQLSTATE: 01005 SQLERRP: DSNXEDC3      


SASISSUS.gif
Super Contributor
Posts: 282

Re: Facing problem while extracting the data from table SAS 9.2.

Ask a Question
Discussion stats
  • 1 reply
  • 177 views
  • 0 likes
  • 2 in conversation