View previous topic :: View next topic
|
Author |
Message |
abhilashapandey
New User
Joined: 22 Nov 2006 Posts: 12 Location: Delhi
|
|
|
|
In my input file, there is a field having values of A, B, C or D etc of one char.
In my output file I want all A or B to be written as 'Y' and all C or D or rest to be written as 'N'.
Ex:
Input
1111 A
2222 B
3333 C
4444 D
5555 X
6666 Z
Output
1111 Y
2222 Y
3333 N
4444 N
5555 N
6666 N
Could anyone please suggest what should be sort card or how can i do it with Sort.
Thanks. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Here's a DFSORT job that will do what you asked for:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
INREC IFTHEN=(WHEN=(6,1,SS,EQ,C'A,B'),OVERLAY=(6:C'Y')),
IFTHEN=(WHEN=NONE,OVERLAY=(6:C'N'))
/*
|
|
|
Back to top |
|
|
abhilashapandey
New User
Joined: 22 Nov 2006 Posts: 12 Location: Delhi
|
|
|
|
Hey Thanks a ton for your quick response.
I used it, and got my work done.
Please let me know what does 'SS' mean in the following
WHEN=(164,1,SS,EQ,C'A,E,G,L,R,X,Y,Z')
OVERLAY=(164:C'Y')),
IFTHEN=(WHEN=NONE,OVERLAY=(164:C'N'))
and when=none means for the rest of values or something else.
Thanks in advance. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
abhilashapandey
New User
Joined: 22 Nov 2006 Posts: 12 Location: Delhi
|
|
|
|
Thnaks alot for your guidance. |
|
Back to top |
|
|
|