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
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
does ibm sort work the same as sync sort
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 *
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) - email@example.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 ...
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