Defining a Database Using Non-SQL › Defining a Subschema › RECORD Statements

RECORD Statements

RECORD statements identify records to be included in this subschema. The record descriptions are copies from the schema descriptions. Depending on the verb and options coded, the RECORD statements can also:

• Specify which record elements can be accessed through the subschema
• Specify which DML verbs can be issued against the record
• Specify the order in which record descriptions occur within the subschema
• Modify, delete, display, or punch a subschema record description

The subschema compiler applies RECORD statements to the current subschema.

Procedure

1. Name the record
2. Optionally identify the elements that can be accessed through the subschema
3. Specify which DML verbs will not be allowed

Note:

• A simple ADD RECORD statement copies a record in its entirety includingall its elements from the schema description into the subschema definition.
• You can change the order of the elements from that specified in the schema.
• You can add additional security and control by restricting the DML commands that programs using this subschema can issue against each record.

Example

The following example shows the definition of the record SKILL being copied into the current subschema.

add record skill
  store is not allowed
  erase is not allowed.