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
 
Sort both the variables in ascending order and remove Dups

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Interview Questions
Author Message
uma rao
Currently Banned
New User


Joined: 20 Oct 2007
Posts: 9
Location: delhi
PostPosted: Tue Oct 30, 2007 12:55 pm    Post subject: Sort both the variables in ascending order and remove Dups
 Reply with quote
please clarify it

We have an Input File having Branch Numbers & Account Numbers. We want to sort it on both the variables in ascending order and remove the duplicates also. How to achieve this through JCL?
Back to top
View user's profile Send private message
References
PostPosted: Tue Oct 30, 2007 12:55 pm    Post subject: Re: Sort both the variables in ascending order and remove Dups Reply with quote
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad
PostPosted: Tue Oct 30, 2007 1:00 pm    Post subject:
Reply with quote
Hi,

SORT FIELDS=(2,10,CH,A,10,20,CH,A)
SUM FIELDS=NONE

This would sort as well as Eliminates the duplicates.

Cheers
Ashwin
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Interview Questions All times are GMT + 6 Hours
Page 1 of 1