Run the command script to the right.
With all the application objects created, execute the code to see the
following processing steps:
- Call the procedure tax_pay to calculate the tax_payable
by an employee depending on his income and update the payroll table.
- Update the payroll table with the tax proof submitted by the employees.
For ease of demonstration, set tax exemption for each employee as 100,000 and proof submitted by the employee as 50,000.
- After all the employees of a department submit their tax proofs, update the calculate_tax column of payroll table to 1.
This update invokes the trigger tax_update.
- Execute RUNSTATS command to update the created temporary table cgtt.tax_cal to update statistics.
- CALL the table function to print the IT sheet for the employees.
You should see success and success with warnings messages in the lower right.
The success with warnings messages indicate that values in an entire table will be changed,
it is expected for this tutorial.