IBM Mainframe Forum

Hi All,

Can some one help me identifying duplicates in a file which has a key field and tag them with character 'D' i.e adding a new column which identifies it as a duplicate record in the same file. Regards,
Rakesh MS

rakeshsneha1212 wrote:Hi All,

Can some one help me identifying duplicates in a file which has a key field and tag them with character 'D' i.e adding a new column which identifies it as a duplicate record in the same file. Regards,
Rakesh MS

Keys fields constitutes of three fields 1,9,CH,10,10,CH,22,12,CH. we need to identify the duplicate and then overlay with 'D' if it is identified as a duplicate record.

Please note it's a single flat file which contains records

Are you talking about duplicate keys only or the whole record being a duplicate? And it is a data set not a 'file'.

NicC wrote:Are you talking about duplicate keys only or the whole record being a duplicate? And it is a data set not a 'file'.

only the key being duplicate. yeah,data set corrected.

regards,
Rakesh MS

Group the records on the key, assigning a sequence number to each record within the group. Reset the squence number on change of group. When writing out drop the sequence number if it is '1' otherwise replace by 'D'. Samples of this sort of thing abound within the forum.