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
 

 

retaining only duplicates in outputfile

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

New User


Joined: 22 Jun 2006
Posts: 13
Location: mumbai

PostPosted: Thu Jul 26, 2007 6:06 pm    Post subject: retaining only duplicates in outputfile
Reply with quote

hi
i have a input file contains 1000 record and near about 30 colums are in the file, i want to print only duplicates records in my JCL.
is it any way we can specified in sort field
we know for removing duplicates
we put sumfield= none
for reatining duplicates what we can do
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Thu Jul 26, 2007 6:22 pm    Post subject:
Reply with quote

If you have a new question, start a new thread in the correct forum.....
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Jul 26, 2007 7:13 pm    Post subject:
Reply with quote

satish1978

check the Keep dropped duplicate records (XSUM) Smart DFSORT Trick at

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
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 Jul 26, 2007 9:02 pm    Post subject:
Reply with quote

Quote:
i want to print only duplicates records in my JCL


How you would do this depends on what exactly you mean by "print only duplicate records".

If you want to keep the second and subsequent record with each duplicate value, you can use DFSORT/ICETOOL's SELECT with FIRST and DISCARD.

If you want to keep all records with duplicate values (no unique records), you can use DFSORT/ICETOOL's SELECT with ALLDUPS.

If you want to keep the first record of those with duplicate values, you can use DFSORT/ICETOOL's SELECT with FIRSTDUP.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Matching files, retaining original so... Andy N SYNCSORT 6 Tue Sep 09, 2014 3:19 pm
No new posts SORT CARD to remove duplicates & ... mkk157 DFSORT/ICETOOL 17 Tue Jul 08, 2014 9:04 pm
No new posts Remove the duplicates without sorting... maki_psg JCL & VSAM 13 Tue May 13, 2014 10:32 pm


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