IBM Mainframe Forum

Hello. I've looked through some similar posts here, as well as checking out publibz.boulder.ibm.com. I'm not sure if this can be done via JCL commands. Any feedback would be appreciated.

I have 2 similar files. One is a running total. One is a daily total. Each evening, I want to update the running total with data from the daily total. For example (the column headings aren't actually on the file):

Daily Total


Running Total


If there are any matcing records between the 2 files, Joe and John Smith for example, I want to combine the total's together (leaving one record on the Running Totals file). If any record is present on the Daily Total file, but not on the Running Total file, I want to add it to the Running Total file. Sample output would be:

updated Running Total



Is this possible? Would it be a SORT statement utilizing SUM FIELDS?
Thanks

Would it be a SORT statement utilizing SUM FIELDS?

You would concatenate the two files as SORTIN and use a SORT statement for the Name field and a SUM statement for the fields to be summed.

The exact statements depend on the starting position, length and format of the Name, Apples, Oranges and Bananas fields. If you want more specific help with this, give me that information.

BTW, the output for John Smith/Bananas should be 2 rather than 0 ... right?

Frank Yaeger wrote:

BTW, the output for John Smith/Bananas should be 2 rather than 0 ... right?

Nice catch, my friend! I think I can figure it out from here, thanks for the feedback.