Author |
Message |
Topic: Need to convert numeric field to char in Rexx exec |
mcclr
Replies: 6
Views: 2838
|
Forum: TSO and ISPF Posted: Tue Jul 24, 2007 2:36 pm Subject: Need to convert numeric field to char in Rexx exec |
Kolusu,
Not necessarily. It seems to create a numeric variable whether it is left justified or not.
Example:
/* REXX */
a = ' 123'
b = 123 ... |
Topic: Need to convert numeric field to char in Rexx exec |
mcclr
Replies: 6
Views: 2838
|
Forum: TSO and ISPF Posted: Tue Jul 24, 2007 1:20 pm Subject: Need to convert numeric field to char in Rexx exec |
We are reading in a file that contains 10 bytes of data that is all numeric in column 1. We are using DSNREXX to issue a DB2 select statement with this variable in the WHERE clause.
SELECT NAME F ... |
Topic: Write only first n messages in OUTFILs with Syncsort |
mcclr
Replies: 11
Views: 7087
|
Forum: Utilities Posted: Tue Jul 10, 2007 5:31 pm Subject: Write only first n messages in OUTFILs with Syncsort |
Thanks for the help.
Kolusu's solution of two steps is superior to our 4 step solution.
Thanks to Frank for the enhancement request for a STOPAFT option on OUTFIL and for the IFTHEN WHEN SEQNU ... |
Topic: Write only first n messages in OUTFILs with Syncsort |
mcclr
Replies: 11
Views: 7087
|
Forum: Utilities Posted: Tue Jul 10, 2007 10:42 am Subject: Write only first n messages in OUTFILs with Syncsort |
Thanks kolusu. We would prefer doing this in one pass, but 2 is better than the 4 we may end up with. The lrecl is 243 and the recfm is fb.
Alissa,
I would also be interested in any other ways ... |
Topic: Write only first n messages in OUTFILs with Syncsort |
mcclr
Replies: 11
Views: 7087
|
Forum: Utilities Posted: Mon Jul 09, 2007 3:04 pm Subject: Write only first n messages in OUTFILs with Syncsort |
Thanks for the update, Alisssa. I tried your suggestion, but only the first OUTFIL contained any records. My understanding of the ENDREC parm is that it is specifying how many input records to proce ... |
Topic: Write only first n messages in OUTFILs with Syncsort |
mcclr
Replies: 11
Views: 7087
|
Forum: Utilities Posted: Mon Jul 09, 2007 1:03 pm Subject: Write only first n messages in OUTFILs with Syncsort |
We are trying to read an input file and split it into 3 files depending on values in columns 1 to 4. We only want the first 700000 records in each of the 3 OUTFILs. We believe that we could do it in ... |
Topic: Dynamically create USERDATA= parms |
mcclr
Replies: 2
Views: 2271
|
Forum: Job Control Language(JCL) Posted: Wed Jan 11, 2006 10:28 am Subject: Dynamically create USERDATA= parms |
Thank you for the suggestion. This would work very well except that they want the jobstream to remain under CA7 control so that if it abends, it will be reflected in CA7. Operations is not required ... |
Topic: Dynamically create USERDATA= parms |
mcclr
Replies: 2
Views: 2271
|
Forum: Job Control Language(JCL) Posted: Tue Jan 10, 2006 5:16 pm Subject: Dynamically create USERDATA= parms |
We have a need to dynamically create userdata parms. We need to send a dataset as an email, which we are able to do using VPS email, but we do not want to hard code the userdata information in the jo ... |
|