IBM Mainframe Forum

Hi,

I want to patch some data in the master file but have no idea how to do it using SORT/ICETOOL.

Master File A:

0030000123456789....................1E.............. (1000 bytes)
0030000223456789....................2E.............. (1000 bytes)
0030000323456789....................2E.............. (1000 bytes)
0030000423456789....................2E.............. (1000 bytes)
0030000523456789....................1E.............. (1000 bytes)
0030000623456789....................2A.............. (1000 bytes)
where first 16 byte is a unique key value, offset 160-161 contains a S9(2) signed numeric value (stores a counter value)

Work File B:

0030000223456789..........2A....... (200 bytes)
0030000423456789..........1A....... (200 bytes)
0030000523456789..........1C....... (200 bytes)
where first 16 byte is a unique key value, offset 55-56 contains a S9(2) signed numeric value; key in work file B always exists in master file A.

Now, I want to add up the counter value for matching key and replace this value in master file A.

Final output file C looks like

0030000123456789....................1E.............. (1000 bytes)
0030000223456789....................4F.............. (1000 bytes)
0030000323456789....................2E.............. (1000 bytes)
0030000423456789....................3F.............. (1000 bytes)
0030000523456789....................2H.............. (1000 bytes)
0030000623456789....................2A.............. (1000 bytes)

Please help.

Regards,
Jim

Jim,

The following JCL will give you the desired results

Thanks skolusu. I got the desired results.

After the sum, there are some records that have a new counter value of 0. If I want to have an output file that only contains counter value > 0, can I do it in STEP0200 as well? Or should I have another step to filter out records that have counter value > 0?

Yes, you can do it in STEP0200 with an OUTFIL INCLUDE=(...) statement.