VALIDATE

Defining a Database Using Non-SQL › Defining a Schema › VALIDATE

VALIDATE

Schema Status

CA IDMS/DB requires that a valid schema reside in the dictionary before any other activity involving the database can begin. Each schema in the dictionary carries a status of either IN ERROR or VALID as follows:

Status	Indicates...	Status set by...
IN ERROR	The schema was not processed by an error-free VALIDATE statement and prevents other CA IDMS/DB software (subschema compiler and utilities) from using the schema	After the execution of an ADD SCHEMA or MODIFY SCHEMA statement
VALID	The schema is usable by other CA IDMS/DB software	After error-free execution of the VALIDATE statement

Only the schema compiler updates the status.

Verification

VALIDATE causes the schema compiler to verify the relationships among all components of the schema that is current for update. Based on this verification, the schema compiler takes one of the following actions:

Result	Compiler action
No errors found	Compiler sets schema status to VALID
Errors found	Compiler issues messages indicating the exact nature of each error

Other Results of VALIDATE

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

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

Procedure

Issue the VALIDATE statement:

validate.