Dupes in one file, rest in another



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Dupes in one file, rest in another

Postby sharma_deepu » Thu Feb 03, 2011 3:30 pm

I have 2 datasets that contain duplicate and non-duplicate elements so I need two output datasets: all duplicates in one and all non-duplicates in the other.
sharma_deepu
 
Posts: 2
Joined: Thu Feb 03, 2011 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Dupes in one file, rest in another

 

Re: Dupes in one file, rest in another

Postby skolusu » Thu Feb 03, 2011 10:42 pm

sharma_deepu,

Use the following DFSORT JCL which will give you the desired results

//STEP0100 EXEC PGM=ICETOOL                             
//TOOLMSG  DD SYSOUT=*                                   
//DFSMSG   DD SYSOUT=*                                   
//IN       DD *                                         
A                                                       
A                                                       
B                                                       
C                                                       
C                                                       
C                                                       
//DUPS     DD SYSOUT=*                                   
//UNQ      DD SYSOUT=*                                   
//TOOLIN   DD *                                         
  SELECT FROM(IN) TO(UNQ) DISCARD(DUPS) NODUPS ON(1,1,CH)
//*
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: Dupes in one file, rest in another

Postby hailashwin » Sat Feb 05, 2011 10:21 am

Hi Kolusu,
It makes me wonder why you had gone in for the ICETOOL step instead of the traditional SORTXSUM (atleast for me :| ) for this particular scenario. I am asking this because, from the time I have started to read abt Sort and appreciate it...I have been hearing from ppl that a ICETOOL step is performance intensive than a normal sort. But I havent had the chance to do the compare myself.
Please correct my understanding..

Thanks,
Ashwin.
hailashwin
 
Posts: 5
Joined: Wed Jan 05, 2011 5:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Dupes in one file, rest in another

Postby dick scherrer » Sat Feb 05, 2011 10:48 am

Hello,

I have been hearing from ppl that a ICETOOL step is performance intensive than a normal sort
One must use care in choosing who to listen to. . . Many people have opinions that have no basis in reality - but they sometimes appear quite knowledgable. . .

The biggest causes of "intensive performance" is the number of records to be processed and how many passes over the data are used to arrive at the solution. Some of the worst performing "solutions" to be seen are when the developer was determined to use the smallest possible set of control statements rather than put in a bit of effort to get to a more efficient process.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Dupes in one file, rest in another

Postby Frank Yaeger » Mon Feb 07, 2011 11:51 pm

I have been hearing from ppl that a ICETOOL step is performance intensive than a normal sort.


People say a lot of things. That doesn't necessarily make them true. A blanket statement like that is not true.

DFSORT does NOT support XSUM. The job Kolusu showed is DFSORT's equivalent of the XSUM function. For more information, see the "Keep dropped duplicate records (XSUM)" Smart DFSORT Trick at:

http://www.ibm.com/support/docview.wss? ... g3T7000094
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post