Syncsort Get the total number of records for a key

eytellene · Posted: Tue Jun 16, 2009 5:37 pm

Hi Experts,

Is it possible for syncsort to get the number of records of the same key, and output the record key and its record count.

Thanks

enrico-sorichetti · Posted: Tue Jun 16, 2009 5:42 pm

Alissa Margulies · Posted: Tue Jun 16, 2009 9:31 pm

eytellene,

What is the position and length of your key field(s)?
Is the data set fixed or variable?

eytellene · Posted: Tue Jun 16, 2009 9:50 pm

Hi Alissa,

The datasets are fixed.

Input 1: file length 90, key 1 is in position 1, 12 bytes. key 2 is position 13, integer
11111111111112
22222222222210
33333333333322

Input 2: file length 50, key 1 is in position 1,12 bytes; key 2 position 13,integer

11111111111112
11111111111112
11111111111112
22222222222210
22222222222210
33333333333322

Output must be file length, 30 ,key 1 position 1,12 bytes,key 2 position 13, integer;number of records in file 2 with the same key 1 and 2 in file 1 position 15

1111111111111203
2222222222211002
3333333333332201

Thanks in advance

Alissa Margulies · Posted: Tue Jun 16, 2009 10:09 pm

Here is a SyncSort for z/OS job that will do what you asked:

eytellene · Posted: Wed Jun 17, 2009 10:29 am

Hi Alissa,

Thanks a lot

It worked .....!!!!!!