SORT for Aggrigate function

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: SORT for Aggrigate function

Postby BillyBoyo » Mon Jan 02, 2012 4:42 pm

If you search for DFSORT SUMMARY REPORT you can find examples. Also you'll find examples in the manuals.
Global moderator
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: SORT for Aggrigate function

Postby Frank Yaeger » Tue Jan 03, 2012 6:09 am


If you want to write a grand total for the input amounts, you can use DFSORT's OUTFIL with TRAILER1 and TOTAL.

If you want to do something with an existing report as input, you'll need to do something fancier. What you'd do depends on exactly what your input looks like, the RECFM and LRECL, etc, which is not clear.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from: ... g3T7000080
Frank Yaeger - DFSORT Development Team (IBM) -
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at
User avatar
Frank Yaeger
Global moderator
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times




  • Related topics
    Last post