Execution of Totalling

If field processing is terminated normally:

• Update totalling adds change in value of the field to the target
• Downdate totalling subtracts the change in value from the field
• Report totalling adds the final value of the field to the target

Otherwise, when field processing is terminated with request to delete:

• Update totalling subtracts current value of field from target
• Downdate totalling adds current value of field to target
• Report totalling still adds the final value of the field to the target

If a condition on any total value is not met, execution of the procedure body returns TERMINATED and terminates in the same way as after a commit failure –all records which should have been updated are re read from the database.