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
 

 

Count of records by grouping using SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
d_sarlie

New User


Joined: 22 Apr 2008
Posts: 32
Location: coimbatore

PostPosted: Wed Jul 23, 2014 11:05 pm    Post subject: Count of records by grouping using SYNCSORT
Reply with quote

I want to write a sort card using SYNCSORT to group values present in column 23 - 3bytes and column 36 - 3 bytes and get the count

The value in 23 position - 3 byte is not always HJU,MKL,DOS,WIN,NEN,NEW,HEW

It is the same with column 36 - 3 bytes

The ONE INPUT FILE IS



***************************** Top of Data ***********
2015304ALI3E7ANHHJH747HJU2013-05-01WER
2011504ALI3HRSDSDSD272HJU2013-05-29JUE
2015304ALI3IVUEFG09642MKL2013-05-01WER
2011504ALI3I1RTRTRT059DOS2013-05-01FEP
2011354GEN0SJFER22980RHJU2013-04-26WER
2015305GEN0T9ZIONEREREDOS2013-04-26SIN
2011304GEN0VTKRT92567RWIN2013-04-26FUL
2015304GEN1ZLDGFHSDFHDNEN2013-04-24WER
2011354GEN1ZMDFDFDRERENEN2013-04-26WER
20W1304GEN20YEREREREREHEW2013-05-29QTC
2011W04GEN21U643756634NEN2013-05-29WER
**************************** Bottom of Data *********
2ND INPUT FILE

**************************
WER
QTC
HMJ
**************************
The ouput I require is

WER HJU 2
WER MKL 2
QTC HEW 1
WER NEN 3

Can someone help me with this.
Back to top
View user's profile Send private message

d_sarlie

New User


Joined: 22 Apr 2008
Posts: 32
Location: coimbatore

PostPosted: Wed Jul 23, 2014 11:29 pm    Post subject: Reply to: Count of records by grouping using SYNCSORT
Reply with quote

The ouput I require is

WER HJU 2
WER MKL 2
QTC HEW 1
WER NEN 3
HMJ 0
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 -> SYNCSORT 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