IBM Mainframe Forum

hello colleagues!
I need to add sequence number to each group of records, like unique word ids...

input:


output:


and file contains billions of records, so how to do this with maximum performance?
can you help me please. Thanks in advance!

Hello,

A few questions before we look at the solution:
a. You do not want the records to be sorted while padding the ID? The output you've shown retains the original order of records.
b. Is there a possibility of a unique group record to appear again somewhere down the line, if so how do you want that handled; for example:


c. You've mentioned that there can be billions of records in input, but you've shown unique identifiers of 4 bytes only, which would mean that it can accommodate maximum of '9999' unique identifiers.

Solution to the query is fairly straight forward unless the aforementioned complexities are not added to it; you need to group the records and PUSH an ID to it. DFSORT allows 15 bytes zoned decimal id to be pushed in, which means 999,999,999,999,999 is the maximum value:



Output:

the number of records is NOT related to the number of groups/identifiers

Hello Mr. Sorichetti,

enrico-sorichetti wrote:the number of records is NOT related to the number of groups/identifiers

Yes, I completely agree; but going by the representative data, there are certain records which have only one entry (instead of paired/grouped entries).
Hence the SORT card written gives the solution for maximum possible groups; TS is expected to tweak it to fit his needs.
I'd be very-very surprised if ONLY 9999 groups were possible in the actual 'billions of records'.

Best regards.

Dmitriy wrote:... and file contains billions of records ...

And if if my uncle was a woman he'd be my aunt...

Which PHB has come up with this ludicrous time-wasting requirement?