Schema Statements › REGENERATE Statement › Usage

Usage

Effect of REGENERATE on Subschemas

In response to the REGENERATE statement, the schema compiler identifies each subschema that must be regenerated and verifies the relationships among the components of each identified subschema. Based on this verification, the schema compiler takes one of the following actions:

• If it finds no errors, the compiler invokes the subschema compiler to create subschema tables and store the tables as a load module in the dictionary load area (DDLDCLOD). The subschema is marked as VALID.
• If it finds errors, the compiler issues messages indicating the name of the invalid subschema and the exact nature of each error and marks the subschema IN ERROR. The DBA uses these messages to determine what changes must be made for the subschema to be valid and uses the subschema compiler to make any necessary changes to the subschema.

Using the subschema compiler to regenerate subschemas

Alternatively, after modifying and validating a schema, the DBA can use the subschema compiler (IDMSUBSC) to validate and regenerate subschemas. To regenerate subschemas, use either the schema compiler or the subschema compiler: using both causes needless duplication of processing. Note that if a subschema requires changes in addition to those necessitated by changes in the schema, the DBA need not use REGENERATE. The DBA can, after validating the schema, use the subschema compiler both to make the additional changes and to generate the new subschema load module.