retreiving max count records using Syncsort

sguhan · New User Joined: 15 Mar 2010 Posts: 9 Location: Chennai

Hi, I tried to use the JCL in retreiving max count records using DFSORT

For the below scenario the above logic is not working. Also, the above logic is not working on SYNCSORT version 1.3 as it shows an error on HIT=NEXT

For Example :
My input file is as below - (Key length is 20 bytes)

000000000111111 020100511
000000000111111 020100514
000000000111111 020100514
000000000111111 120100511
000000000111111 120100514
000000000111111 120100514
000000000111112 020100521
000000000111112 020100524
000000000111112 020100524

The output file should be

000000000111111 020100514
000000000111111 120100514
000000000111112 020100524

But the output that I am getting is

000000000111111 020100511
000000000111111 020100514
000000000111111 120100511
000000000111112 020100521
000000000111112 020100524

which is wrong.

Also, If I have 2 or more dates which occurs maximum number of times for a prticular key combination,
I should get all those dates which has maximum occurences in the output.

For example:
The input file is

000000000111111 020100511
000000000111111 020100514
000000000111111 020100514
000000000111111 020100516
000000000111111 020100516
000000000111111 020100517
000000000111111 020100517
000000000111111 120100511
000000000111111 120100514
000000000111111 120100514
000000000111111 120100516
000000000111111 120100516
000000000111112 020100521
000000000111112 020100524
000000000111112 020100524

Then the output file should be

000000000111111 020100514
000000000111111 020100516
000000000111111 020100517
000000000111111 120100514
000000000111111 120100516
000000000111112 020100524

Could you please help me on this.

dick scherrer · Posted: Thu Jun 03, 2010 8:23 pm

Hello,

You have Syncsort and this part of the forum is for dfsort questions. . .

If your support people will install the current release of Syncsort, hit=next will work.

Alissa Margulies · Posted: Tue Jun 15, 2010 8:55 pm

sguhan,

IFTHEN with HIT=NEXT is supported in SyncSort for z/OS 1.3.0. Support for WHEN=GROUP was included in SyncSort for z/OS 1.3.2. What release of SyncSort are you running so that we can help to provide you with an appropriate solution.