Subschema Statements › VALIDATE Statement › Usage

Usage

Effect of VALIDATE on Subschemas

When the subschema compiler validates the subschema, it takes one of the following actions:

• If it finds no errors, the compiler sets the subschema's status to VALID. A VALID status means the subschema load module can be generated.
• If it finds errors, the compiler issues messages indicating the exact nature of each error and sets the subschema's status to IN ERROR. The DBA uses these messages to determine what changes must be made for the subschema to be valid.

Must Validate the Subschema Following ADD and MODIFY

The subschema compiler also sets the subschema's status to IN ERROR under these conditions:

• The subschema was just created with an ADD SUBSCHEMA statement
• The subschema was modified with a MODIFY SUBSCHEMA statement
• The schema associated with the subschema was modified in a way that affects the subschema; for example, a set deletion
• Any component of the subschema as added, modified, or deleted

VALIDATE Typically Used to Check Errors

VALIDATE is typically used for dry runs of the subschema compiler, since it causes the compiler to check the components but not to create subschema load modules.