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');