You can specify ENABLED or DISABLED as the only object
modes for triggers on tables, and for triggers on views, and for indexes
that allow duplicate values.
You can specify the modes for triggers or duplicate indexes.
Modes for Triggers and Duplicate Indexes
If you specify no mode for an index or for a trigger when you create
it or in a subsequent SET Database Object Mode statement, the object
is enabled by default.
Example
of changing the mode of an index
The following example of
the SET INDEXES statement disables the unique acc_num_ix index.
which was created in ENABLED mode by default:
Here the SET
INDEXES statement used the Object-list format to specify the index
by name. Because no other index is defined on the accounts table,
the following SET INDEXES statement that uses the Table format has
the same effect:
SET INDEXES FOR accounts DISABLED;
Example of changing mode of a trigger
The
following example enables a backup_accts trigger that was created
in DISABLED mode: