Adding an extension to one record in an input file

[Steven Shroyer]

Following the original requirements, I created a report which shows all events processed in the current or previous day. If any event was in progress when the report runs, it creates a seperate entry for the last transaction processed at the end of the file (used a seperate step and MOD on the file). This could be 2 seperate files if that makes things easier. What I am trying to do, due to an updated request, is add that last transaction record to the end of the line with a MTHD_CD of 'I'. Below is sample data.

Code: Select all

+------------------------------------------------------------------- 
| MATCHING_EVENT_ID |        LAST_MNT_TS         | STATUS | MTHD_CD   
+------------------------------------------------------------------- 
1_|  1111111111111    | 2016-03-25-12.58.13.994260 | C      | 4       
2_|  2222222222222    | 2016-03-25-12.58.22.093537 | C      | 4       
3_|  3333333333333    | 2016-03-25-13.53.48.501055 | C      | 2       
4_|  4444444444444    | 2016-03-26-11.24.44.075004 | I      | 2       
+------------------------------------------------------------------- 
+--------------------------------------------------------+           
| CUST_ID  |    TRANS_ID    |        LAST_MNT_TS         |           
+--------------------------------------------------------+           
1_|    319   |  16086000708   | 2016-03-26-11.24.57.184656 |         
+--------------------------------------------------------+           

I would like this to read as follows, if possible (created by moving the second column headers to the end of the original column header row and the transaction record to the end of the event row with a STATUS of 'I'). I have looked at using JOINKEYS or going the ICETOOL route rather than syncsort but have not been able to figure out anything that would work yet. Any ideas would be greatly appreciated. LRECL is 133 for the file.

Code: Select all

+-------------------------------------------------------------------+--------------------------------------------------------+   
| MATCHING_EVENT_ID |        LAST_MNT_TS         | STATUS | MTHD_CD   | CUST_ID  |    TRANS_ID    |        LAST_MNT_TS         |
+-------------------------------------------------------------------+--------------------------------------------------------+   
1_|  1111111111111    | 2016-03-25-12.58.13.994260 | C      | 1       
2_|  2222222222222    | 2016-03-25-12.58.22.093537 | C      | 1       
3_|  3333333333333    | 2016-03-25-13.53.48.501055 | C      | 2       
4_|  4444444444444    | 2016-03-26-11.24.44.075004 | I      | 2   |   999   |  123456789012   | 2016-03-26-11.24.57.184656 |
+-------------------------------------------------------------------+--------------------------------------------------------+
 

[BillyBoyo]

You'll need to show your existing code.