IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Restriction on the number of columns using TBCREATE


 
IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 197
Location: india

PostPosted: Wed Sep 17, 2014 11:33 am
Reply with quote

Hello,


Would like to know if there is any restriction in creating the number of columns using TBCREATE.

I am using the below code in REXX

Code:

"ISPEXEC TBCREATE ENTRY KEYS(DATEKEY TIMEKEY)                   
 NAMES(EDATE ADATE REFNO UID AID DDESC DDESC1 DDESC2 DDESC3     
       DDESC4 DDESC5 DDESC6 DDESC7 DDESC8 DDESC9 DDESC10 DDESC11
       DDESC12 DDESC13 DDESC14 DDESC15 DDESC16 DDESC17 DDESC18   
       DDESC19 DDESC20 DDESC21 DDESC22 DDESC23 DDESC24 DDESC2   
       DDESC26 DDESC27 DDESC28 DDESC29 DDESC30)                 
 WRITE LIBRARY(ENTRY)"                                           
                                                                 

Giving me an error :-

Code:
IRX0030I Error running LOGTST, line 24: Name or string > 250 characters


Please assist.

Thank you,
Rajat
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10695
Location: italy

PostPosted: Wed Sep 17, 2014 12:10 pm
Reply with quote

there is no restriction on the number of columns ( apart those set by db2 )

You just need to use the right rexx syntax when defining/using a string
( read the manual about it, especially the section about CONTINUING a line )

anyway the message is misleading
it is right that a name/identifier cannot be longer than 250 chars
not the same for a string , I used strings up to 32k !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> TSO/ISPF
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Parsing more than 1000 columns in a s... SYNCSORT 10
No new posts Export columns from DB2 table with pi... DB2 14
No new posts Sort to construct single record from ... SYNCSORT 3
No new posts position, start pos, length of column... SYNCSORT 14
No new posts count the number of records from diff... CA Products 4

Back to Top