Previous Topic: Schema and Subschema CompilersNext Topic: SCHEMA Statement

Defining a Database Using Non-SQL › Defining a Schema

Defining a Schema

Order of Schema Component Definition

When you add a new schema to the dictionary, you must submit the ADD SCHEMA statement first. Although you can add most statements in any order, cross references to nonexistent components generate error messages. To avoid error messages, submit statements in this order:

  1. SCHEMA statement
  2. AREA statements
  3. RECORD statements (and associated ELEMENT substatements)
  4. SET statements
  5. VALIDATE statement

Note: If VALIDATE is not executed successfully, the schema cannot be used by other software components. (Subschemas cannot be defined and utilities that require the schema name as input cannot be executed.)