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
|
Copyright © 2014 CA.
All rights reserved.
|
|