Subschema Statements › SUBSCHEMA Statement › Examples

Examples

Minimum SUBSCHEMA Statement

The following example supplies the minimum SUBSCHEMA statement required for the purpose of later establishing a functional subschema:

add subschema name is dehss01
  of schema empschm version 100.

Securing the subschema for LRF Usage

This example modifies subschema DEHSS01 so that any program that uses the subschema must first be registered. It also designates that these programs can access logical records only.

mod subschema dehss01
   program registration is on
   usage is lr .

Registering a User For All Operations

This example indicates user DEH has authority to perform all basic entity operations and to issue the PUBLIC ACCESS clause. All other users are allowed to display or punch the subschema.

mod subschema dehss01
   include user deh
       registered for all
   public access is allowed for display.

Documenting Subschema Revisions

In the following example, the DBA documents subschema revisions and the purpose of those revisions; note that the DBA first defined revision number as a class in the dictionary:

modify subschema name is culss01
    prepared by dba  password is tennis
    revision number is '6.5'
        text is 'accommodate new billing restrictions'.

Note: For more information about when to specify LR CURRENCY RESET or NO RESET, see the CA IDMS Logical Record Facility Guide.