Posted: Tue Nov 16, 2004 7:25 am Post subject: Change col value based on another column in SORT
In a file, on Col 8, I can have values ranging from 1 to 5. During SORT, i shld chk col 8 for 5 and populate Col 10 with Y and for other values of Col 8, i should populate Col 10 with N"..what is the sort card for this
Here is a short explanation of the job.
1. Copy 1 to 9 bytes from the input file as such.
2. In 10th position of the output file copy the 8th column from the input file and use CHANGE command to do the IF-THEN-ELSE replacements as you requested.
3. Copy the remaining data i.e from 11 to end of record. Note: I assumed that the input file is RECFM=FB and LRECL=80. You need to change the job to support your needs.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum