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
 

 

Building totals

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
oerdgie

New User


Joined: 22 Nov 2007
Posts: 55
Location: Germany

PostPosted: Mon May 12, 2014 6:01 pm    Post subject: Building totals
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting sum on Totals and Adjusted to... balaji81_k DB2 6 Fri Mar 24, 2017 7:51 pm
No new posts Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts Building Sort Card dynamically using ... rikdeb SYNCSORT 3 Sat Nov 15, 2014 6:08 pm


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