View previous topic :: View next topic
|
Author |
Message |
Mohit Verma
New User
Joined: 19 Mar 2008 Posts: 1 Location: Providence
|
|
|
|
I have a file containing 1.2 Million records. I need to space out (replace with blanks) i.e. x'40' on a set of columns if the value on that column is not a particular numeric value for ex 5. |
|
Back to top |
|
|
rajatbagga
Active User
Joined: 11 Mar 2007 Posts: 199 Location: india
|
|
|
|
Hi Mohit,
Mohit Verma wrote: |
to space out (replace with blanks) i.e. x'40' on a set of columns |
What are the those column positions?
Mohit Verma wrote: |
if the value on that column is not a particular numeric value for ex 5. |
How do you identify which numeric value should be present in that column?
Its better if you can show us with an example what exactly you need...
Regards,
Rajat |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Mohit Verma,
Without knowing your record layout or format, here is a basic example that you can modify for your needs:
Code: |
//SORT1 EXEC PGM=SORT
//SORTIN DD *
AAAAA
BBBB5
CCCC5
DDDD2
EEEEE
FFFF8
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
INREC IFTHEN=(WHEN=(5,1,CH,NE,C'5'),OVERLAY=(5:X'40'))
SORT FIELDS=COPY
/* |
This is the output produced:
Code: |
AAAA
BBBB5
CCCC5
DDDD
EEEE
FFFF |
If this does not meet your needs, then please be more specific and provide sample input and output. |
|
Back to top |
|
|
|