IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

File sorting and summing up values at specific location


 
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kenshin

New User


Joined: 02 Aug 2014
Posts: 16
Location: Saint Paul , USA

PostPosted: Wed Sep 23, 2015 2:14 am
Reply with quote

Hi All ,

I need your help in achieving following results.

Input file:
A 10
A 20
A 30
B 05
B 10
C 30

Output file:
A 60
B 15
C 30
Total 105

can the total be added by adding trailer ?
could anyone help me out with this?
[/code]
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Wed Sep 23, 2015 3:36 am
Reply with quote

Yes, OUTFIL reporting features. REMOVECC, TRAILER1 with TOT(AL), TRAILER3 with SECTIONS for your key, and TOT again.
Back to top
View user's profile Send private message
kenshin

New User


Joined: 02 Aug 2014
Posts: 16
Location: Saint Paul , USA

PostPosted: Wed Sep 23, 2015 5:14 am
Reply with quote

Thank you for quick response ,Bill

I will try adding the keywords you mentioned in my sort card and will share my results.

Thanks
Sumedh
Back to top
View user's profile Send private message
kenshin

New User


Joined: 02 Aug 2014
Posts: 16
Location: Saint Paul , USA

PostPosted: Sat Sep 26, 2015 9:29 am
Reply with quote

It worked !!

SORT FIELDS=(56,2,CH,A,2,6,CH,A)
SUM FIELDS=(59,7,ZD)
OUTREC OVERLAY=(59:59,7,ZD,EDIT=(IIIIIIT))
OUTFIL FNAMES=SORTOUT,REMOVECC,
TRAILER1=(22:'TOTAL HOMESAVER RECORDS
TOT=(59,7,UFF,EDIT=(IIIIIIT)))


Thanks Bill
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts How to find which file contains my se... DFSORT/ICETOOL 6
No new posts IGZ0035S THERE WAS AN UNSUCCESSFUL OP... COBOL Programming 3
No new posts Creating additional seqnum/Literal wh... DFSORT/ICETOOL 4
No new posts Hex Value - vb file replace old date ... DFSORT/ICETOOL 14

Back to Top