Schema Statements › VALIDATE Statement › Usage

Usage

Effect of VALIDATE on schema

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

• If it finds no errors, the compiler sets the schema's status to VALID. VALID indicates that the schema is usable by other CA IDMS/DB software.
• If it finds errors, the compiler sets the schema's status to IN ERROR and issues messages indicating the exact nature of each error. The DBA uses these messages to determine what changes must be made for the schema to be valid. As long as the status is IN ERROR, other CA IDMS/DB software (such as the subschema compiler and utilities) cannot use the schema.

Must validate the schema following ADD and MODIFY

The schema compiler sets the schema's status to IN ERROR after the successful execution of an ADD SCHEMA or MODIFY SCHEMA statement. You must validate the schema to make it available to other CA IDMS/DB software.

VALIDATE resolves pointers

In addition to the verification described above, VALIDATE causes the schema compiler to resolve the pointer positions for which AUTO was specified in set description statements.

VALIDATE can be used at any time during schema definition

The VALIDATE statement can be used at any time to verify the relationships of schema components. For example, if the DBA has not yet defined sets, but wishes to verify the schema's record structures, VALIDATE can be used; in this case, however, the DBA should anticipate a warning for records whose location mode is VIA an undefined set.