Sum Fields=none

View All Questions

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:


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:

Frank Yaeger - DFSORT Development Team (IBM) -
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols,  Migration                                                      
DFSORT/MVS is on the Web at

Add your reply below ...

This site allows you to ask questions and get answers from various posters, you may also answer any posts if you feel like you have input to give. Feel free to ask for help with any new question you wish, but most of the questions here are tech related. You will find many questions and answers related to your Ipod or Ipod Nano, Itunes, audio and video converting, spyware or adware cleanup, pc or other computer questions, and even mainframe questions. Although these are the tech questions most often asked, you will find help on almost any computer or software related subject. Feel free to go to the main menu and review the posts already present, or feel free to ask your own question. (Some questions will be closed once the moderator feels they are sufficiently answered and that no other input is needed).

See All Tips        Iphone Apps

Your Name:

Your Reply:

Type in verification code:

Main Menu

Shareware and Freeware Database

Tasks and Spyware Database

Various Computer Help Topics