View previous topic :: View next topic |
Author |
Message |
abhikush Beginner
Joined: 26 Dec 2002 Posts: 12 Topics: 3
|
Posted: Fri Apr 16, 2004 2:41 pm Post subject: Eliminating non-duplicate records |
|
|
Is there a way by which we can eliminate non-duplicate records using SORT.
Let's say I have records:
1
1
1
2
3
4
4
4
4
The output file should look like:
1
1
1
4
4
4
4 |
|
Back to top |
|
|
Frank Yaeger Sort Forum Moderator
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Fri Apr 16, 2004 3:01 pm Post subject: |
|
|
You can use the SELECT operator of DFSORT's ICETOOL with ALLDUPS to do that. Here's the DFSORT/ICETOOL job:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
1
1
1
2
3
4
4
4
4
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,1,CH) ALLDUPS
/*
|
For complete information on DFSORT's ICETOOL, see:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA00/6.0?DT=20031124143823 _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
Back to top |
|
|
abhikush Beginner
Joined: 26 Dec 2002 Posts: 12 Topics: 3
|
Posted: Fri Apr 16, 2004 3:06 pm Post subject: |
|
|
Thanks Frank. I will try it out. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|