ACL 9
Tutorial 1 Solution
COMMANDS:
ANALYZE –> TOTAL
ANALYZE –> PROFILE
ANALYZE –> STATISTICS
SAMPLING –> SAMPLE
ANALYZE –> SEQUENCE
DATA –> SORT
ANALYZE –> DUPLICATES
ANALYZE –> GAPS
AP_TRANS
1. Using the TOTAL command, develop a hash control total and an amount control total
for AP-TRANS.
What recommendation would you make to develop a field for hash control total?
Ans:
TOTAL command: Invoice Amount plus one of the other number fields.
