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 SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 5 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm


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