Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

retreiving max count records using Syncsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sguhan

New User


Joined: 15 Mar 2010
Posts: 9
Location: Chennai

PostPosted: Thu Jun 03, 2010 1:06 pm    Post subject: retreiving max count records using Syncsort
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 03, 2010 8:23 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Jun 15, 2010 8:55 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us