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

SET Statements

SET statements identify sets to be included in this subschema. The set description is copied from the schema description. Depending on the verb, the SET statements can also:

• Determine which DML verbs can be issued against the set
• Modify, delete, display, or punch a subschema set description

The subschema compiler applies SET statements to the current subschema.

Procedure

1. Name the set
2. Optionally specify which DML verbs will not be allowed

Note:

• If the set's owner record is deleted, either from theschema or from the subschema, the set is automatically deleted from the subschema.
• If the set's member record is deleted, either from the schema or from the subschema, the set remains in the subschema.
• If a set is added to the subschema, the owner of the set must also be added to the subschema
• If one or more sets associated with a record is not included in the subschema, certain update operations on the record are prohibited, as follows:
  • If a set in which the record is an owner is missing, the record cannot be erased
  • If a set in which the record is a member is missing, the record cannot be erased and:
    • If the set has a membership of AUTOMATIC, the record cannot be stored
    • If the set is sorted, the record cannot be modified

Example

The following example shows the definition of the set SKILL-EXPERTISE being copied into the current subschema.

add set name is skill-expertise.