MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 8 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Need to convert numeric field to char in Rexx exec
mcclr

Replies: 6
Views: 2838

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group