RECREATE_TRIGGERS procedure¶
Recreates all the inoperative triggers associated with the specified table from their definitions in the system catalogue.
Prototypes¶
RECREATE_TRIGGERS(ASCHEMA VARCHAR(128), ATABLE VARCHAR(128))
RECREATE_TRIGGERS(ATABLE VARCHAR(128))
Description¶
RECREATE_TRIGGER is a utility procedure which recreates all the inoperative triggers defined against the table specified by ASCHEMA and ATABLE, using the SQL found in the system catalogue tables. It is useful for quickly recreating triggers which have been marked inoperative after a change to one or more dependencies. If ASCHEMA is omitted it defaults to the current schema.
Parameters¶
- ASCHEMA
- If provided, the schema containing the table to recreate inoperative triggers for. If omitted, this parameter defaults to the value of the CURRENT SCHEMA special register.
- ATRIGGER
- The name of the table to recreate inoperative triggers for.
Examples¶
Recreate all inoperative triggers defined against the FINANCE.LEDGER table:
CALL RECREATE_TRIGGERS('FINANCE', 'LEDGER');
Recreate all inoperative triggers defined against the EMPLOYEE table in the current schema:
CALL RECREATE_TRIGGERS('EMPLOYEE');
See Also¶
- Source code
- RECREATE_TRIGGER procedure
- SYSCAT.TRIGGERS (built-in catalogue view)