|
View previous topic :: View next topic
|
| Author |
Message |
ajayvamsi
New User
.jpg)
Joined: 21 Jul 2005
Posts: 56
Location: Hyderabad
|
|
|
|
Hi all,
I have an input file which I need to get the unique records only below is the example
file
1
1
2
3
4
4
5
output (which Iam expecting is)
2
3
5
will this be possible using ONLY SORT?
if so could any one help me with the respective card
ajay |
|
| Back to top |
|
 |
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
ajayvamsi,
You can use SELECT operator with NODUPS parm of DFSORT's ICETOOL to get the desired results.
| Code: |
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
1
1
2
3
4
4
5
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,1,CH) NODUPS
//*
|
Hope this helps...
Cheers |
|
| Back to top |
|
|
ajayvamsi
New User
Joined: 21 Jul 2005
Posts: 56
Location: Hyderabad
|
|
|
|
| we dont have icetool in our shop could you please help me using sort ? |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| we dont have icetool in our shop could you please help me using sort ? |
If you have DFSORT, then you have DFSORT's ICETOOL. ICETOOL has been shipped with DFSORT since 1991.
Why do you think you don't have ICETOOL? |
|
| Back to top |
|
|
|
|
