File Matching › Listing Accounts Without Transactions › Demonstration

Demonstration

Objective

This report lists accounts that do not have transactions. The match-file run matches a multiple-transaction file against a single-occurrence master file.

Procedure

• MB=KEEP retains a master file in the input buffer.
• A SELECT BUFFER statement selects those accounts without transactions.

  Note: Type 7 logic (IF M-ACCOUNT LE T-ACCOUNT DROP) can be used instead of the SELECT BUFFER statement.

The contents of the input buffer:

Complete Code

 col. 2
 ▼
 IN  80 MK=M-ACCOUNT MB=KEEP               $Keep master record
 REC M-ACCOUNT     1    5           'ACCOUNT'
 REC M-BRANCH      6    2           'BRANCH'
 REC M-NAME        19  20           'NAME'

 IN 80 MK=T-ACCOUNT
 REC T-ACCOUNT     1     5          'ACCOUNT'
 SEL BUFFER WHEN T-ACCOUNT EQ '     ' $Accounts without transactions
 80OUT D
 80SORT M-BRANCH -
 803 LIST OF ACCOUNTS WITHOUT TRANSACTIONS
 8051*010 M-BRANCH                HR
 8051*020 M-ACCOUNT               HR
 8051*030 M-NAME                  HR

Result

REPORT NO. 80  LIST OF ACCOUNTS WITHOUT TRANSACTIONS      mm/dd/yy PAGE     1
                         BRANCH                        ACCOUNT                                NAME

                           32                           15999                         SHELLY BROWN


                           35                           27777                         ANDY PIGGOTT


                           40                           32115                         BOB DATO