Frank Swarbuck on IBM Mainframe Discussion List <[email protected]> wrote on 10/19/2010 01:37:16 PM: > I just needed a quick and dirty program to tell me how many > "duplicate" records were in a file. > I ended up doing something else, though I've already forgotten what! > But I will review your ideas more thoroughly later.
My first recommendation was based on getting both totals and counts, which is what I thought you originally asked for. If you just want a count of the duplicate records, the OCCUR operator of DFSORT's ICETOOL will do that quite easily: OCCUR FROM(IN) LIST(OUT) ON(p,m,f) ON(VALCNT) ALLDUPS For more information on what you can do with OCCUR, see: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/7.11?DT=20100630155256 Frank Yaeger - DFSORT Development Team (IBM) - [email protected] Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
