Example: A bank wants to produce a report of inactive customer accounts. These are accounts for which there have been no recent transactions. The record layout for the transaction file was described previously in the figure SQZ Subparameter and the record layout was described in the figure Sample SQZ subparameter.
This can be done by doing the same join as detailed in the figure Sample of Modified Records, but only
retaining the unpaired records from the master
file (SORTJNF2) through the use of the JOIN
control statement. This is known as a “right outer join.”
Figure 1. JCL and Required Control Statements
The output from this example is:
Figure 2. Sample Output
