JCL for removing duplicates in a dataset



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

JCL for removing duplicates in a dataset

Postby pavan.kanugo » Tue Mar 25, 2008 12:41 pm

hai,
i am trying to sort a dataset on one field and remove the duplicates on another field in a single step. Can anybody suggest me an idea to do so.
for example the dataset look like the following

Emp-Id Emp-Name Salary project Employer


i want to sort it based on salary and remove the names which duplicated

thanks and regards.............
pavan
pavan.kanugo
 
Posts: 5
Joined: Tue Mar 25, 2008 12:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for removing duplicates in a dataset

 

Re: JCL for removing duplicates in a dataset

Postby arunprasad.k » Tue Mar 25, 2008 3:09 pm

Here you go!!

//S1     EXEC PGM=ICETOOL                                               
//TOOLMSG  DD SYSOUT=*                                                 
//DFSMSG   DD SYSOUT=*                                                 
//IN1      DD *                                                         
----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
123456 KUMAR 300                                                       
123457 SAM   200                                                       
123458 PETER 100                                                       
123457 SAM   200                                                       
/*                                                                     
//OUT      DD SYSOUT=*                                                 
//TOOLIN   DD *                                                         
  SELECT FROM(IN1) TO(OUT) ON(8,5,CH) FIRST  USING(CTL1)               
/*                                                                     
//CTL1CNTL DD *                                                         
  SORT FIELDS=(14,3,ZD,A)                                               
/*                                                                     


Output
123458 PETER 100                                                               
123457 SAM   200                                                               
123456 KUMAR 300                                                               


Refer the following link to know more about DFSORT select statement.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.11?DT=20060615185603

Post if you have any questions.

Arun.
arunprasad.k
 
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for removing duplicates in a dataset

Postby pavan.kanugo » Tue Mar 25, 2008 5:32 pm

Thank u arun

i have tried the code that u have suggested, but my output is in contrast with your output. It is as following

123457 SAM 200
123458 PETER 100
123456 KUMAR 300

instead of

123458 PETER 100
123457 SAM 200
123456 KUMAR 300

Can u plz recheck it.

thank and regards....
pavan
pavan.kanugo
 
Posts: 5
Joined: Tue Mar 25, 2008 12:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for removing duplicates in a dataset

Postby arunprasad.k » Tue Mar 25, 2008 6:29 pm

It is woring good for me. See your sysout and check whether CTL1CNTL statements are executed or not.

Best way is to open the link which I have given and read the manuals. It has detailed explaination with examples.

Arun.
arunprasad.k
 
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for removing duplicates in a dataset

Postby MrSpock » Tue Mar 25, 2008 7:35 pm

Worked for me too with DFSORT. Maybe the O/P is using SYNCSORT?
User avatar
MrSpock
Global moderator
 
Posts: 810
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 2 times

Re: JCL for removing duplicates in a dataset

Postby pavan.kanugo » Tue Mar 25, 2008 7:50 pm

hai arun
i have got the right thing after going through the link
thanks alot
bye....bye....

regards...
pavan
pavan.kanugo
 
Posts: 5
Joined: Tue Mar 25, 2008 12:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for removing duplicates in a dataset

Postby Frank Yaeger » Tue Mar 25, 2008 8:45 pm

Arun's "solution" happens to work for the example he gave because the two records with SAM have the same amount. It will NOT work if two records with the same name have different amounts. For example, if the input is:

123456 KUMAR 300     
123457 SAM   200     
123458 PETER 100     
123457 SAM   200     
123457 SAM   300     


The output would be:

123458 PETER 100       
123457 SAM   200       
123456 KUMAR 300       
123457 SAM   300       


Notice that SAM appears twice in the output.

This DFSORT/ICETOOL job would work for the general case:

//S1     EXEC PGM=ICETOOL                                     
//TOOLMSG  DD SYSOUT=*                                         
//DFSMSG   DD SYSOUT=*                                         
//IN1      DD *                                               
123456 KUMAR 300                                               
123457 SAM   200                                               
123458 PETER 100                                               
123457 SAM   200                                               
123457 SAM   300                                               
/*                                                             
//T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(,PASS)     
//OUT      DD SYSOUT=*                                         
//TOOLIN   DD *                                               
SELECT FROM(IN1) TO(T1) ON(8,5,CH) FIRST                       
SORT FROM(T1) TO(OUT) USING(CTL1)                             
/*                                                             
//CTL1CNTL DD *                                               
  SORT FIELDS=(14,3,ZD,A)                                     
/*                                                             


The output would be:

123458 PETER 100 
123457 SAM   200 
123456 KUMAR 300 


Of course, it's not clear which salary you want in the output when a name is associated with two different salaries.
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

Re: JCL for removing duplicates in a dataset

Postby arunprasad.k » Tue Mar 25, 2008 9:48 pm

Thanks Frank for correcting me.

Its a fact that you know DFSORT better than what I do. :)

Arun.
arunprasad.k
 
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for removing duplicates in a dataset

Postby Frank Yaeger » Wed Mar 26, 2008 1:03 am

Its a fact that you know DFSORT better than what I do.


Not surprising given that I develop the DFSORT code and write all of the documentation. ;)
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

Re: JCL for removing duplicates in a dataset

Postby pavan.kanugo » Wed Mar 26, 2008 6:19 pm

thank u frank

it is a good observation which i have not noticed
thank alot for giving the solution

pavan
pavan.kanugo
 
Posts: 5
Joined: Tue Mar 25, 2008 12:19 pm
Has thanked: 0 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post