ENABLE_TRIGGER procedure¶
Enables the specified trigger by restoring its definition from a table.
Prototypes¶
ENABLE_TRIGGER(ASCHEMA VARCHAR(128), ATRIGGER VARCHAR(128))
ENABLE_TRIGGER(ATRIGGER VARCHAR(128))
Description¶
Restores a previously disabled trigger by reading its definition from DISABLED_TRIGGERS and recreating it. The trigger must have been disabled with DISABLE_TRIGGER procedure or DISABLE_TRIGGERS procedure.
Parameters¶
- ASCHEMA
- If provided, the schema containing the trigger to enable. If omitted, defaults to the value of the CURRENT SCHEMA special register.
- ATRIGGER
- The name of the trigger to enable.
Examples¶
Enable the FINANCE.LEDGER_INSERT trigger:
CALL ENABLE_TRIGGER('FINANCE', 'LEDGER_INSERT');
Enable the EMPLOYEE_UPDATE trigger in the current schema:
CALL ENABLE_TRIGGER('EMPLOYEE_UPDATE');
See Also¶
- Source code
- DISABLE_TRIGGER procedure
- ENABLE_TRIGGERS procedure
- SYSCAT.TRIGGERS (built-in catalogue table)