Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Need to Sort out the repeated values

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
balukanna

New User


Joined: 09 Apr 2008
Posts: 15
Location: chennai
PostPosted: Mon May 12, 2008 5:02 pm    Post subject: Need to Sort out the repeated values
 Reply with quote
hi,

i need to sort out the repeated values

ex:

i/p

456 200
567 100
456 200
567 200
789 300

o/p

456 200
456 200
Back to top
View user's profile Send private message
References
PostPosted: Mon May 12, 2008 5:02 pm    Post subject: Re: Need to Sort out the repeated values Reply with quote
V S Amarendra Reddy

Active User


Joined: 13 Sep 2006
Posts: 73
Location: INDIA
PostPosted: Mon May 12, 2008 5:34 pm    Post subject:
Reply with quote
Hi,

This DFSORT/ICETOOL job will give you the desired result.

Code:

//SORT     EXEC PGM=ICETOOL                   
//TOOLMSG  DD  SYSOUT=*                                       
//DFSMSG   DD  SYSOUT=*                                       
//IN   DD  *                                             
456 200                                                       
567 100                                                       
456 200                                                       
567 200                                                       
789 300                                                       
/*                                                           
//OUT  DD  SYSOUT=*                                       
//TOOLIN   DD  *                                             
SELECT FROM(IN) TO(OUT) ON(1,3,CH) ON(5,3,CH) ALLDUPS
/*


Here I assumed the the two fields are different so we have two on fields.

Regards
Amar
Back to top
View user's profile Send private message
balukanna

New User


Joined: 09 Apr 2008
Posts: 15
Location: chennai
PostPosted: Wed May 21, 2008 10:41 am    Post subject:
Reply with quote
hi Amar,

sorry for the delay...

thanks a lot...
its working fine...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1