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

SET Statements

The SET statements identify and describe a set. Depending on the verb, the SET statements can add, modify, delete, display, or punch the set description (see 14.7, “SET Statement").

Note that if a set's owner record is deleted, the set is automatically deleted. Additionally, the deleted record and set are deleted from all subschema descriptions associated with the current schema. However, if the member record is deleted, the set remains. To delete the set (if it has no other member records), use the DELETE SET statement.

The schema compiler applies SET statements to the current schema.

The ADD SET statement creates a new set description in the dictionary and associates it with the current schema.

Procedure

1. Name the set
2. Specify order
3. Specify the mode
4. Specify owner and members
5. Specify set options

Note:

• If you intend to have prior pointers, do not forget to specify MODE IS CHAIN LINKED TO PRIOR.
• If you are creating a system-owned index, the owner is SYSTEM.

Example

The following example shows a SET statement.

add set name is insplan-rider
  order is last
  mode is chain
  owner is insplan
  member is rider
  mandatory automatic.

SAME AS

The SAME AS clause copies an entire set description including order, mode, owner, and members from a set in another schema into the current schema. SAME AS must precede all other optional clauses.