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 first       
    
    Note: 
    • 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.