|
View previous topic :: View next topic
|
| Author |
Message |
swapnilushinde
New User
Joined: 17 Mar 2009
Posts: 30
Location: Bangalore.India
|
|
|
|
Hello
I am trying to remove the duplicate as well as original rows from input datastet to one output dataset and other output dataset should contain all remaining rows...It should work like this..
| Code: |
Input : ( Key position 1-3)
123 abc
123 ffff
345 xtz
456 mnp
345 ggg
Output1 : ( Duplicate and original rows)
123 abc
123 ffff
345 xtz
345 ggg
Output2 : (Remaing unique rows)
456 mnp |
I could achieve output1 with SUM FIELD=NONE and match unitilty in two different steps..But again I need to delete these duplicates from input to create output2..This is going to be very tedious work for huge files..
Is it possible in one/tow SORT steps..
Please help me on this.. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Here's what I use
| Code: |
//ICETOOL EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD *
123 ABC
123 FFFF
345 XTZ
456 MNP
345 GGG
/*
//PRT DD SYSOUT=*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN1) TO(PRT) ON(1,3,CH) NODUPS DISCARD(OUT) |
|
|
| Back to top |
|
|
swapnilushinde
New User
Joined: 17 Mar 2009
Posts: 30
Location: Bangalore.India
|
|
|
|
Hi Expat
Thanks a lot..it worked for me..One last thing..Could you please provide me manual of ICETOOL.. If yes then it will be great for me !!! |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| There is a sticky topic at the head of the form "DFSORT / ICETOOL Reference material" where Frank has set up links to the different documents. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
| Back to top |
|
|
swapnilushinde
New User
Joined: 17 Mar 2009
Posts: 30
Location: Bangalore.India
|
|
|
|
Hi Expat and Frank
Thanks for all your help !!! |
|
| Back to top |
|
|
|
|
