Data Description Phase › Generator Control Statements › SUBSCHEMA Statement

SUBSCHEMA Statement

The SUBSCHEMA statement names the subschema, associates it with a schema, and permits informational entries. The generator copies all area, record, and set descriptions included in the schema, providing access to the entire CA IDMS/DB database as defined in the schema. The generator also appends VALIDATE and GENERATE statements to produce a subschema load module. The subschema load module thus created is used by the runtime interface to satisfy database requests issued from Total application programs.

Syntax

The following is the syntax for the SUBSCHEMA statement. All clauses must begin between columns 8 and 11, with the exception of the OF SCHEMA NAME clause, which must be coded between columns 12 and 72.

►►── SUBSCHEMA ───────────────────────────────────────────────────────────────►

 ►── SUBschema name is subschema-name ────────────────────────────────────────►

 ►──┬───────────────────────────────────────────────────────────────────────┬─►
    └─ of SCHema name is schema-name ─┬───────────────────────────────────┬─┘
                                      └─ Version is ─┬─ version-number ─┬─┘
                                                     ├─ HIGhest ────────┤
                                                     └─ LOWest ─────────┘

 ►──┬──────────────────────────────┬─ . ──────────────────────────────────────►◄
    └─┬─ PREpared ─┬─ by user-id ──┘
      └─ REVised ──┘

Parameters

SUBSCHEMA

Required keyword; must occupy a line by itself and begin in column 1.

SUBSCHEMA NAME IS subschema-name

Identifies the source description of the subschema to the data dictionary. Subschema-name must be a 1- to 8-character value. The first character must be #, $, @, or A through Z. The remaining characters can be #, $, @, A through Z, 0 through 9, or the hyphen (except as the last character or following another hyphen). Subschema-name also becomes the CSECT name of the object subschema. If the object subschema subsequently is link edited alone for dynamic loading, subschema-name must be the load library member name.

OF SCHEMA NAME schema-name

Associates the named subschema with the generator-created schema. Schema-name must be the name of the schema identified in the SCHEMA statement.

VERSION version-number

Qualifies schema-name with a version number. Version-number must be an unsigned integer between 1 and 9999.

PREPARED/REVISED BY user-id

Identifies the user who is preparing the subschema. PREPARED/REVISED BY is informational only.

Example

The following is an example of the SUBSCHEMA control statement.

SUBSCHEMA
       SUBSCHEMA NAME IS ETOTSUBS OF SCHEMA ETOTSCHM.