Program logic
The EXECUTE_VALIDATION program determines the processing sequence for multiple tables in scope as follows:
- Generates the dependency tree for the tables in scope using the FK-references between the tables.
- Determines the processing sequence as follows:
If TABLE_GROUP_NAME is specified If processing_sequence is defined for all tables in the specified table group, then the processing_sequence from the table group is used in ascending order Else the tables in scope are processed using the generated dependency tree: Tables with no dependency or tables depending only on already processed tables are processed firstNote:- If the INCLUDE_USER_DATA parameter is set to Y, the processing sequence is determined in the same way for Inbox and Planning Configuration tables that are included in the validation.
- If the INCLUDE_USER_DATA parameter is set to N, the processing sequence is determined in the same way only for Inbox tables that are included in the validation.
The EXECUTE_VALIDATION program determines the execution end status as follows:
- Success: When all tasks are completed with the Success status, the end status is set to Success.
- Warning: When any task is completed with the Warning status and no tasks are completed with the Failure status, the end status is set to Warning.
- Failure: When any task is completed with the Failure status, the end status is set to Failure.