|
|
| 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 |
|
 |
References
|
 Posted: Mon May 19, 2008 8:34 pm Post subject: Re: syncsort blank(fill with ) out one column on a cond |
|
|
|
|
rajatbagga
Active User
Joined: 11 Mar 2007
Posts: 130
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: 200
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 |
|
|
|
|
