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
 
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: 195
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: 10327
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
No new posts Profile changed to NUMBER ON STD (fro... Martylin TSO/ISPF 1 Thu Aug 03, 2017 9:14 am
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts how to mask the phone number kumarinfy DB2 4 Mon Apr 03, 2017 5:23 pm

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