Ask a New Question

  Main Question - Posted From Guest:
if i'm running sort on teh mainframe and using a sum fields=none because I want to eliminate duplicate rows, how many duplicates will it remove and which ones will be removed

Guest Says:
I assume you mean if you have 10 duplicate rows for example? That would mean the first row is kept in your result, while the following 9 duplicate rows are elminated

Guest Says:
does ibm sort work the same as sync sort

Guest Says: the sum fields=none will remove the duplicates but in order to keep the file in order (meaning that the first row is the duplicate row that is saved) you have to use the equals option in the sort also.  I'm not sure what it would be if you don't use that option on the sort

Frank Yaeger Says: If EQUALS is in effect, DFSORT will keep the first record of each set of duplicates.  If EQUALS is not in effect, DFSORT can keep any record of each set of duplicates.  To ensure that the first record is kept, you can use: //DFSPARM DD *   OPTION EQUALS Alternatively, you can use the SELECT operator of DFSORT's ICETOOL, which lets you keep the first or last duplicates, and offers many other options as well.  For complete details on SELECT, see: publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/7.13?DT=20100630155256 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

Add your reply below ...