Given files in user home qualifier:
CUSTOMER: ID ZD(5), NAME CH(30), ADDRESS CH(50), DATE-OF-REGISTRATION YYYYMMDD ZD(8), unsorted
TRANSACT: ID ZD(10), CUSTOMER-ID ZD(5), DATE YYYYMMDD ZD(8), AMOUNT ZD(5), unsorted
Tasks:
create a list of transactions in year 2026 month of September, of customers registrated in 2026
for the filtered customers, calculate the total amount for the transactions
write the result into STAT2609 file in this structure: ID ZD(5), NAME CH(30), YEAR YYYY ZD(4), MONTH MM ZD(2), TOTAL-AMOUNT ZD(7), in CSV format, sorted by customer ID
EXAMPLE FOR FILTER CUSTOMERS, FILTER TRANSACTIONS, JOIN, TOTAL AMOUNT, CSV:
EXAMPLE FOR ...: