Tutorial 1 Solution

Document Type
Essay
Pages
4 pages
Word Count
570 words
School
N/A
Course Code
N/A
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.
The total of Invoice_Amount is: $278,641.33

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.