MVSFORUMS.com

[APLOSDC]

Hi,

I have an input file whose format is:

Tx Date (8 bytes) - all the records will have the same date
Tx Code (1 byte) - the possible values can be 'C' or 'D'
Tx Amount (14 byte ZD filed with no decimals)

I want a summary record created from the above file which should contain:

Tx Date (from input file)
Total number of records in the input file
Sum of all tx amounts of records with tx code 'C'
Sum of all tx amounts of records with tx code 'D'

Can the above be accomplished in a single step?

Many Thanks.

[Frank Yaeger]

Here's a DFSORT job that will do what you asked for. You didn't show what you wanted the output record to look like so I took a guess. You can edit the fields of the output record as appropriate.

[APLOSDC]

Frank,

Many thanks for this. I did the requisite formatting and it worked. A very ingenious application of overlay.