IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Building totals


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

New User


Joined: 22 Nov 2007
Posts: 64
Location: Germany

PostPosted: Mon May 12, 2014 6:01 pm
Reply with quote

Hi there,

I want to use DFSORT to build totals shown below in the output file.

The Input file has three columns :

A number (#01, #02, #nn), a type (A1, ..., A4) and a counter based on the type.

This is the input file :

Code:
#01 A1 7           
#01 A2 2           
#01 A3 1           
#02 A1 3           
#02 A4 6           
#03 A2 4   


this should be the output file :

Code:
       A1 A2 A3 A4  TOT   
#01   7   2   1   0   10   
#02   3   0   0   6     9   
#03   0   4   0   0     4   



Is it possible with DFSORT or ICEMAN ?

Thanks in advance for help
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts building java class with zip4j.jar on... Java & MQSeries 0
No new posts Building a sort key DFSORT/ICETOOL 3
No new posts Getting sum on Totals and Adjusted to... DB2 6
No new posts Need help in building a logic All Other Mainframe Topics 4
No new posts Several errors during building altern... JCL & VSAM 11
Search our Forums:

Back to Top