Defining a Database Using Non-SQL › Defining a Subschema › Subschema Statement

Subschema Statement

What It Does

The SUBSCHEMA statement:

• Identifies the subschema
• Associates it with a schema
• Secures the subschema definition
• Establishes subschema currency

Once a specific subschema becomes current, the subschema compiler applies subsequent statements to that subschema.

Procedure

1. Name the subschema
2. Name the schema from which this subschema is derived
3. Optionally provide a description
4. Specify the usage
5. Optionally include security information
6. Optionally include comments

Note: Be explicit about the usage mode for your subschema. Specify either LR or DML; only in cases where both LRF and DML are used should you specify MIXED (for more information, see the CA IDMS Logical Record Facility Guide document).

Example

The following example shows the definition of the subschema EMPSS01.

add subschema name is empss01
    of schema name is empschm version is 1
    description is 'subschema for adding/modifying employees'
    public access is allowed for all
    usage is lr.