IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Removing duplicate records from a file using sort utility
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
sameer arastu

New User


Joined: 15 Nov 2007
Posts: 2
Location: hyderabad
PostPosted: Fri Oct 09, 2009 5:26 pm
 Reply with quote
Hi,

I want to know how to remove any duplicate records from a PS file using an external sort utility. If it is shown with an example it ll be helpful.

Thanks for the info
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai
PostPosted: Fri Oct 09, 2009 5:27 pm
 Reply with quote
you can use
SUM FIELDS=NONE
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
PostPosted: Fri Oct 09, 2009 6:10 pm
 Reply with quote
I found these two topics:

www.ibmmainframes.com/viewtopic.php?t=43263&highlight=duplicates
www.ibmmainframes.com/viewtopic.php?t=22865&highlight=duplicates

There are probably more out there.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 2
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us