Object Definition Syntax › MODIFY Statement

MODIFY Statement

Changes the way attributes are defined on OBJECT statements. MODIFY statements are read after OBJECT statements.

Syntax

MODIFY obj_name att_name [status_type;]
   [ON_NEW DEFAULT|SET value|NOW ;]|

   [ON_CI DEFAULT|SET value|NOW ;]|

   [ON_DB_INIT DEFAULT|SET value|NOW ;]

Arguments

obj_name

Identifies the object whose attribute is being modified.

att_name

Identifies the attribute being modified.

status_type

Modifies the properties of the attribute to allow or prohibit null values. There are two valid options for this keyword:

REQUIRED

Indicates that the attribute is required.

NOT_REQUIRED

Indicates that the attribute is not required.

ON Statements

See ON Statements for a description of these statements.

Example

The following example changes the salary attribute in the emp object so that it is now a required attribute:

MODIFY emp salary REQUIRED;

Example

The following example changes the address2 attribute in the emp object so that is now not required.

MODIFY emp address2 NOT_REQUIRED;