Previous Topic: Demonstration (2): Using a KEEP ClauseNext Topic: Demonstration (4): Using the RENUMBER Clause


Demonstration (3): Using a DROP Clause

Objective

This example uses the DROP clause to produce the same report as that shown for the KEEP clause in Demonstration (2).

Procedure

A DROP clause is used to leave out DATE, BRANCH, and NAME. ACCOUNT, TRANS-IND, and TRANS-AMT are kept. ADD A LABEL HERE

col. 2
▼
IN 80 F
USE *
    CHANGE RPTNO TO 01 AND
           'ACCOUNT ACTIVITY BY BRANCH' TO 'ACCOUNT ACTIVITY'
    DROP  'DATE' AND 'BRANCH' AND 'NAME'
REC ACCOUNT     1     5          'ACCOUNT'
REC TRANS-IND   6     1          'DEPOSIT/' 'WITHDRAWAL'
REC TRANS-AMT   7    11  2 DP=2  'AMOUNT OF' 'TRANSACTION'
REC DATE       18     6  2       'DATE'
REC BRANCH     24     2
REC NAME       26    20          'NAME'
80OUT D
80SORT NAME 0                           $Dropped
803 ACCOUNT ACTIVITY BY BRANCH          $Title changed
8051*010 BRANCH                         $Dropped
8051*020 ACCOUNT               HR
8051*030 NAME                  HR       $Dropped
8051*050 TRANS-AMT             HR
8051*060 TRANS-IND             HR
8051*070 DATE  FD              HR       $Dropped
END