Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SAS: Unable to detect the DB2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
rajesh1183

New User


Joined: 07 Jan 2008
Posts: 98
Location: Hyderabad

PostPosted: Tue Jan 27, 2009 11:27 am    Post subject: SAS: Unable to detect the DB2 table
Reply with quote

Hi All,

I have a query which I was facing while accessing a DB2 table from SAS program...

I have 2 tables in my environment with names...
1) TAKT_POLICYHOLD_01
2) TAKT_POLICY_EXPIRATION_200811.

I was accessing the DB2 tables in SAS pgm as
Code:

LIBNAME DB2LIB DB2                             
               SSID=D2A1                             
               DBCONINIT="SET CURRENT SQLID='WGAK713'";
 
PROC CONTENTS DATA=DB2LIB.TAKT_POLICYHOLD_01;
RUN;
 
PROC CONTENTS DATA=DB2LIB.TAKT_POLICY_EXPIRATION_200811;
RUN;


I was able to retreive the data about the 1st table whereas when the 2nd table is accessed, I receive an error in the below format...
"The file DB2LIB.TAKT_POLICY_EXPIRATION_200811.DATA has too long a member name for the DB2LIB library.

Even when the 2nd table is used using the PROC SQL statement, I was receiving the same error... Can you give me any clue what went wrong...??

I have tried using named literal style also...i.e.,
"TAKT_POLICY_EXPIRATION_200811"n. Even then I face the same error...

Your help will be highly appreciated....
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 27, 2009 12:27 pm    Post subject:
Reply with quote

Quote:
"The file DB2LIB.TAKT_POLICY_EXPIRATION_200811.DATA has too long a member name for the DB2LIB library.

Isn't the above error message just a smidge of a give away ? icon_rolleyes.gif

The name is too long, therefor it exceeds the maximum allowable length for a name.
Back to top
View user's profile Send private message
rajesh1183

New User


Joined: 07 Jan 2008
Posts: 98
Location: Hyderabad

PostPosted: Tue Jan 27, 2009 12:39 pm    Post subject: Reply to: SAS: Unable to detect the DB2 table
Reply with quote

Actually its a DB2 table name, I am accessing but not a variable name... I think DB2 table can have a max of 32 characters length as its name.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 27, 2009 1:11 pm    Post subject:
Reply with quote

I guess that you have the following option set >> VALIDVARNAME=V7

And you get the same result from PROC SQL ? I can sort of see that PROC CONTENTS might append a .DATA on the end as it expects a DATA file as input.

Can you post the PROC SQL
Back to top
View user's profile Send private message
rajesh1183

New User


Joined: 07 Jan 2008
Posts: 98
Location: Hyderabad

PostPosted: Tue Jan 27, 2009 2:05 pm    Post subject:
Reply with quote

Below is the code... Whereever I use this table name, I am receiving the same error. and I am not using any option called VALIDVARNAME=V7, becoz the default would be V7 only....

Code:

PROC SQL;                                                           

     UPDATE DB2LIB.TAKT_POLICY_EXPIRATION_200811
           SET EXP_DT   =   SUBSTR(SYSPARM(),2,8)
                               
QUIT;                                                               
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 27, 2009 3:10 pm    Post subject:
Reply with quote

Quote:
VALIDVARNAME=V7, becoz the default would be V7 only....


Really, have you checked ?

It allows names of up to 32 characters. Just something that might help you, that's all.
Back to top
View user's profile Send private message
rajesh1183

New User


Joined: 07 Jan 2008
Posts: 98
Location: Hyderabad

PostPosted: Tue Jan 27, 2009 3:32 pm    Post subject:
Reply with quote

The manuals say, the default is V7. Since I haven't mentioned this in the OPTIONS statement, I think, the default would be in effective.

Search this link SAS website

with string as "VALIDVARNAME= System Option"


Can I know the process for checking the default system options that my SAS pgm is using...??
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 27, 2009 3:50 pm    Post subject:
Reply with quote

PROC OPTIONS;
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us