Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Removing duplicate as well as original rows

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
swapnilushinde

New User


Joined: 17 Mar 2009
Posts: 30
Location: Bangalore.India

PostPosted: Thu Feb 18, 2010 1:15 pm    Post subject: Removing duplicate as well as original rows
Reply with quote

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
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Feb 18, 2010 2:53 pm    Post subject:
Reply with quote

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
View user's profile Send private message
swapnilushinde

New User


Joined: 17 Mar 2009
Posts: 30
Location: Bangalore.India

PostPosted: Thu Feb 18, 2010 6:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Feb 18, 2010 6:57 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Feb 18, 2010 10:45 pm    Post subject:
Reply with quote

All of the DFSORT books and papers are available online from:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080

"z/OS DFSORT Application Programming Guide" has complete doc for DFSORT's ICETOOL in Chapter 6.
Back to top
View user's profile Send private message
swapnilushinde

New User


Joined: 17 Mar 2009
Posts: 30
Location: Bangalore.India

PostPosted: Fri Feb 19, 2010 12:00 pm    Post subject:
Reply with quote

Hi Expat and Frank
Thanks for all your help !!!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us