Add duplicate count in record detail, BUT do not remove dups

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
lcammarata
Member
Posts: 1
Joined: Thu Mar 03, 2016 7:49 am

Add duplicate count in record detail, BUT do not remove dups

Post by lcammarata » Thu Mar 03, 2016 7:56 am

Hi,

I'm struggling with a situation where I want to find records in a file that have duplicate values in one part of the record. I can do this, but I also want to retain all records in the output.

Here is the example:

Input:

Infile1:
aaaaa
aaaaa
bbbbb
bbbbb
bbbbb
bbbbb
ccccc


outfile:
aaaaa 2
aaaaa 2
bbbbb 4
bbbbb 4
bbbbb 4
bbbbb 4
ccccc 1

So far I've had no luck accomplishing this. I was able to get this output:

outfile:
aaaaa 2
bbbbb 4
ccccc 1

By doing the following:

INREC FIELDS=(1,5,9:X,SEQNUM,8,ZD)
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=(10,8,ZD)

Can anyone help to ensure I don't actually drop any of the dup records?

Thanks

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others