DFSORT / ICETOOL - add/sum of fields

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
floh
Member
Posts: 5
Joined: Wed Aug 03, 2011 1:12 pm

DFSORT / ICETOOL - add/sum of fields

Post by floh » Wed Nov 07, 2012 2:34 pm

Is it possible to add the content of fields at a certain position and give the sum in the trailer?
The sum shall be computed anyhow and not only for the sort keys.

Exampel:
key field1
01 01
04 01
03 05
03 01
02 02

I want to get as a result:
01 01
02 02
03 01
03 05
04 01
Trailer:
05 10
(count)(sum)

is it possible to use the SUM option though I don't want to sum for each key?
I also found the ADD option for the trailer, but this seems only to be made to change the COUNT field?!

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Wed Nov 07, 2012 2:49 pm

Look at the reporting functions of OUTFIL, TRAILERn, SECTIONS, depending on exactly what you want, and may as well look at HEADERn at the same time even if you don't need it.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others