Submitting Referential Integrity Validation Programs
The referential integrity validation programs described under Master Data and Transaction Data (in the Table Names matrices) are submitted using a batch driver program, CIPVRNVB, and this program is executed in the staging database. Please note that the referential integrity validation programs may also be run in the production environment on occasion, to determine the integrity of data in the production database.
You should supply the following parameters to this program:
• Batch code. The batch code associated with the appropriate table's referential integrity validation program. Refer to each table listed under Master Data and Transaction Data (in the Table Names matrices) for each referential integrity batch code / program.
• Batch thread number. Thread number is not used and should be left blank.
• Batch thread count. Thread count is not used and should be left blank.
• Batch rerun number. Rerun number is not used and should be left blank.
• Batch business date. Business date is the date supplied to the referential integrity validation programs and the date under which statistics will be logged.
• Total number of commits. Total number of commits is not used and should be left blank.
• Maximum minutes between cursor re-initiation. Maximum minutes between cursor re-initiation is not used and should be left blank.
• User ID. User ID is only used to log statistics for the execution of the batch job.
• Password. Password is not used.
• Language Code. Language code is used to access language-specific control table values. For example, error messages are presented in this language code.
• Trace program at start (Y/N), trace program exit (Y/N), trace SQL (Y/N) and output trace (Y/N). These switches are only used during QA and benchmarking. If trace program start is set to Y, a message is displayed whenever a program is started. If trace program at exist is set to Y, a message is displayed whenever a program is exited. If trace SQL is set to Y, a message is displayed whenever an SQL statement is executed.