Operations on Entities › ADD Operations

ADD Operations

ADD (or the synonym CREATE) does the following:

• Adds schema and subschema entity definitions to the dictionary
• Associates entities with the current schema or subschema

If the Entity Already Exists

If the entity already exists in the dictionary, the response of the compiler depends on the value associated with the DEFAULT clause of the SET OPTIONS statement:

• If DEFAULT IS ON is specified, the compiler interprets the ADD as a MODIFY
• If DEFAULT IS OFF is specified, the compiler issues an error message and terminates processing of the statement.

Defaults

You can explicitly code all characteristics of the added entity or accept one or more default characteristics. Default characteristics are established:

• As dictionary options (using the SET OPTIONS statement)
• As session options (using the SET OPTIONS statement)

The syntax statements identify all default values.

Establishes Update Currency

ADD SCHEMA and ADD SUBSCHEMA statements establish update currency for the specified schema or subschema. Schema or subschema entities can be updated once update currency is established.

Note: For a discussion of currency, see 9.7, “Establishing Schema and Subschema Currency”.

Use VALIDATE After ADD

ADD also sets the schema's or subschema's status to IN ERROR. A VALIDATE statement must set the status to VALID before the schema or subschema becomes a usable component.