IBM Mainframe Forum

Hi all,

I have a file (RECFM=FB, LRECL=20) with records that look like the following:



The first 8 bytes is unique, however the data that follows may or may not be unique.

I would like to identify the duplicate values that occur past the first 8 bytes i.e. in bytes 9 through to 20 and report on them.

So, in the above instance, the report should look like:


I'm sure that must be a way to do this using DFSORT and I would appreciate your assistance with this.

Many thanks.

Hello,

Before anything else, the input that you've shown will-not yield the output you're looking for, for example the values for 'D' and 'G' are not same hence cannot be grouped (unless you group them on 10 bytes instead of 12 - which is from column 9 to 20)



Also, please explain the logic behind the below sequence, i.e. how did the 'D', 'G' chunk come before 'E', even when the key sequence value of 9- 20 for 'E' is smaller (which I am assuming is the driver for this process); please also explain if you need spaces after each chunk of grouped items:



The below code yields a similar output, you can tweak it further to add the new sequence or the extra lines with spaces as you'd shown:



Output:

These users thanked the author Aki88 for the post:

Aadil (Fri Mar 10, 2017 3:30 pm)

Hi Aki88,

This is exactly what I was looking for. I would like to see the spacing between each set of data though that is a nice to have and not a necessity.

Many thanks for your assistance, much appreciated.