|
View previous topic :: View next topic
|
| Author |
Message |
balukanna
New User
Joined: 09 Apr 2008
Posts: 41
Location: USA
|
|
|
|
hi,
i need to sort out the repeated values
ex:
i/p
456 200
567 100
456 200
567 200
789 300
o/p
456 200
456 200 |
|
| Back to top |
|
 |
V S Amarendra Reddy
Active User
Joined: 13 Sep 2006
Posts: 216
Location: USA
|
|
|
|
Hi,
This DFSORT/ICETOOL job will give you the desired result.
| Code: |
//SORT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
456 200
567 100
456 200
567 200
789 300
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,3,CH) ON(5,3,CH) ALLDUPS
/*
|
Here I assumed the the two fields are different so we have two on fields.
Regards
Amar |
|
| Back to top |
|
|
balukanna
New User
Joined: 09 Apr 2008
Posts: 41
Location: USA
|
|
|
|
hi Amar,
sorry for the delay...
thanks a lot...
its working fine... |
|
| Back to top |
|
|
|
|
