shankhar
New User
Joined: 29 Dec 2007 Posts: 1 Location: Pune
|
|
|
|
Hi,
I have the following file
Name Phone
------- -------
ABCD 11111
PQRS 22222
ABCD 11111
LMNO 33333
LMNO 33333
I need to sort out only the duplicate for the row "LMNO 33333" from the file and I need the rest of the information in another file, i.e. my output should look like this :
Name Phone
------- -------
ABCD 11111
PQRS 22222
ABCD 11111
LMNO 33333
Can you help me out please ?
Thanks,
Shankhar |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use a DFSORT job like the following to do what I think you asked for:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
ABCD 11111
PQRS 22222
ABCD 11111
LMNO 33333
LMNO 33333
/*
//OUT1 DD SYSOUT=*
//OUT2 DD SYSOUT=*
//SYSIN DD *
OPTION COPY
INREC IFTHEN=(WHEN=(1,10,CH,EQ,C'LMNO 33333'),
OVERLAY=(81:SEQNUM,8,ZD))
OUTFIL FNAMES=OUT1,
OMIT=(1,10,CH,EQ,C'LMNO 33333',AND,81,8,ZD,GT,+1),
BUILD=(1,80)
OUTFIL FNAMES=OUT2,SAVE
/*
|
OUT1 would have:
Code: |
ABCD 11111
PQRS 22222
ABCD 11111
LMNO 33333
|
OUT2 would have:
If that's not what you want, then please explain more clearly what you do want with a better example of input and expected output. |
|