Example: In addition to the Inactive Customers report in the previous example, the bank can produce an exception report of all transactions for which there is no master file customer record, all within the same MFX execution. This is done by also including the unpaired records from the transaction file (a “full outer join”). The output from the join operation consists of records that either have data from the unpaired records in the transaction file or the data from the records in the master file. The missing data will be blanks in each record. These records can then be reformatted and directed into two separate output file reports, as follows.
The SORTOF1 output from this example is:
The SORTOF2 output is:
