Defining a Database Using Non-SQL › Defining a Schema › SCHEMA Statement

SCHEMA Statement

The SCHEMA statement performs the following:

• Identifies the schema
• Secures the schema definition
• Establishes schema currency

When you issue an ADD SCHEMA statement, a new schema description is created in the dictionary. Default values established through the SET OPTIONS statement (see 11.5, “SET OPTIONS Statement”) can be used to supplement the user-supplied description.

ADD also sets the schema's status to IN ERROR. A VALIDATE statement must set the status to VALID before a subschema or CA IDMS/DB utility can reference the schema.

Procedure

1. Name the schema
2. Optionally add descriptive information
3. Optionally specify automatic record ID assignment
4. Optionally identify the schema that this schema is derived from
5. Optionally provide security information
6. Optionally provide comments and user-defined attributes

Examples

The following example shows the minimum SCHEMA statement required to establish a database.

add schema name is sampschm.

The following example shows a complete SCHEMA statement.

add schema name is empschm version is 1
    assign record ids from 3000
    derived from schema oldschm version is 1
    include user is kla registered for all
    public access is allowed for display
    include status is production
    comments 'this schema is based on a former employee schema'
            -'used before the addition of the new divisions'.