SQL Database Implementation for the Commonweather Corporation › Logical Database Definition Listing for the Commonweather Database › Subschema Definition

Subschema Definition

Sample subschema listing for the Commonweather database

A sample subschema listing for the Commonweather database is shown below.

For further information on defining subschemas, see CA IDMS Database Administration Guide.

ADD
SUBSCHEMA NAME IS A200SS03 OF SCHEMA NAME IS EMPSCHM VERSION IS 1
    PUBLIC ACCESS IS ALLOWED FOR ALL
    USAGE IS MIXED
    .
 ADD
AREA NAME IS EMP-DEMO-REGION
    .
 ADD
AREA NAME IS ORG-DEMO-REGION
    PROTECTED UPDATE IS NOT ALLOWED
    EXCLUSIVE UPDATE IS NOT ALLOWED
    .
 ADD
RECORD NAME IS DEPARTMENT
    .
 ADD
RECORD NAME IS EMPLOYEE
    .
 ADD
RECORD NAME IS OFFICE
    .
 ADD
SET NAME IS DEPT-EMPLOYEE
    .
 ADD
SET NAME IS OFFICE-EMPLOYEE
    .