Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Restriction on the number of columns using TBCREATE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 188
Location: india

PostPosted: Wed Sep 17, 2014 11:33 am    Post subject: Restriction on the number of columns using TBCREATE
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Sep 17, 2014 12:10 pm    Post subject: Reply to: Restriction on the number of columns using TBCREAT
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    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts Sequence number add in SORT pshongal SYNCSORT 3 Fri Sep 02, 2016 3:32 pm
No new posts Casting a Binary Number to Numeric in... Bob Steinkraus Java & MQSeries 6 Tue Aug 09, 2016 5:58 pm
No new posts GDG vsersion number change Raghu navaikulam JCL & VSAM 5 Fri May 27, 2016 4:49 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us