ENABLE_TRIGGERS procedure¶
Enables all triggers associated with a specified table.
Prototypes¶
ENABLE_TRIGGERS(ASCHEMA VARCHAR(128), ATABLE VARCHAR(128))
ENABLE_TRIGGERS(ATABLE VARCHAR(128))
Description¶
Enables all the disabled triggers associated with a particular table. Note that this does not affect inactive triggers which are still attached to the table, just those triggers that have been disabled with DISABLE_TRIGGER procedure or DISABLE_TRIGGERS procedure. To reactivate inactive triggers, see RECREATE_TRIGGER procedure and RECREATE_TRIGGERS procedure.
Parameters¶
- ASCHEMA
- If provided, the schema containing the table for which to enable triggers. If omitted, defaults to the value of the CURRENT SCHEMA special register.
- ATABLE
- The name of the table to enable all disabled triggers for.
Examples¶
Enable all disabled triggers on the FINANCE.LEDGER table:
CALL ENABLE_TRIGGERS('FINANCE', 'LEDGER');
Enable the disabled triggers for the EMPLOYEE table in the current schema:
CALL ENABLE_TRIGGERS('EMPLOYEE');
See Also¶
- Source code
- DISABLE_TRIGGERS procedure
- RECREATE_TRIGGER procedure
- ENABLE_TRIGGER procedure
- SYSCAT.TRIGGERS (built-in catalogue table)