Usage

How to submit the VALIDATE statement

You submit the VALIDATE statement only through the batch command facility. You must run the batch command facility in local mode.

When to use VALIDATE

If you have loaded a group of tables using a phased or stepped LOAD and built the indexes and relationships of the tables specifying NO VALIDATE in the BUILD statement, use VALIDATE to ensure that referencing tables have valid references.

You can also use the VALIDATE utility at any time to validate the referential constraints of a table.

VALIDATE utility uses intermediate work files

STEP1 of the VALIDATE utility produces an intermediate work file to be used by STEP2. If you run a complete VALIDATE without separating STEP1 from STEP2, data is sorted in the intermediate file between the steps automatically. If you run a stepped VALIDATE, you must run the intermediate sorts.

Note: When running a complete VALIDATE, SYS002 and SYS003must point to the same intermediate file. When running a stepped VALIDATE, SYS002 and SYS003 must point to different intermediate files. The data that is output in SYS003 by STEP1 is input to STEP2 in SYS002.

When not to use VALIDATE

If you loaded the tables with a complete LOAD, or if you did not specify NO VALIDATE in the BUILD statement, then the validation has already been done. There is no need to run the VALIDATE utility.

If the tables have no referential constraints, there is no need to run the VALIDATE utility.

Note: For more information about referential constraints, see the CA IDMS Database Administration Guide.