Merging 2 files whlie summing together duplicate records

[D9988]

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

Code: Select all

Name                      Apples             Oranges          Bananas
Joe Smith                      1                   1                2
John Smith                     1                   0                2
Michelle Smith                 0                   2                0         

Running Total

Code: Select all

 
Name                      Apples             Oranges          Bananas
Joe Smith                    10                   10                10
John Smith                   5                    5                 0

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

Code: Select all

Name                      Apples             Oranges          Bananas
Joe Smith                     11                   11                   12
John Smith                     6                    5                    0
Michelle Smith                 0                    2                    0

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

[Frank Yaeger]

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?

[D9988]

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.