|
View previous topic :: View next topic
|
| Author |
Message |
Anbutheone
New User
Joined: 08 Oct 2008
Posts: 15
Location: Bangalore
|
|
|
|
I have a file with duplicate records. My requirement is to have one file without any duplicates and another file with the remaining records.
Say input file is
AAA
AAA
BBB
BBB
BBB
Outfile1 should be
AAA
BBB
Outfile2 should be
AAA
BBB
BBB
Can we do this in ICETOOL or anyother SORT methods? |
|
| Back to top |
|
 |
ssmukul
New User
Joined: 22 Jan 2008
Posts: 19
Location: India
|
|
|
|
Hi,
Yes, we can do this in ICETOOL. Below job will do what you have asked for:
| Code: |
//STEP1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN DD *
AAA
AAA
BBB
BBB
BBB
//SORTOUT DD SYSOUT=*
//SORTXSUM DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,3,CH) FIRST DISCARD(SORTXSUM)
/* |
Thanks. |
|
| Back to top |
|
|
Anbutheone
New User
Joined: 08 Oct 2008
Posts: 15
Location: Bangalore
|
|
|
|
Thanks ssmukul for the quick reply..
I ll try this.. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
| Back to top |
|
|
|
|
