Modes for Triggers and Duplicate Indexes:
.-ENABLED--.
|--+-DISABLED-+-------------------------------------------------|
You can specify the modes for triggers or 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.
Related statements: ALTER TABLE, CREATE TABLE , CREATE INDEX, CREATE TRIGGER, START VIOLATIONS TABLE, and STOP VIOLATIONS TABLE
For a discussion of object modes and violation detection and examples that show how database object modes work when users execute data manipulation statements on target tables or add new constraints and indexes to target tables, see the IBM Informix Guide to SQL: Tutorial.
For information on the system catalog tables associated with the SET Database Object Mode statement, see the descriptions of the sysobjstate and sysviolations tables in the IBM Informix Guide to SQL: Reference.