▪To use the stored procedure that a trigger calls, provide the catalog,schema/owner and name of the table on which the trigger is defined and specify whether to enable or disable the triggers on the table.
▪To create a trigger on a table, you must have DBA authority or be the owner of the table on which the trigger is being defined.
▪You can define, by default, up to one trigger for each combination of table,action (INSERT, UPDATE, DELETE) and time (BEFORE and AFTER). This means there can be a maximum of six triggers per table.
Note The triggers are applied to each row. This means that if there are ten inserts, a trigger is executed ten times.
▪You cannot define triggers on a view (even if the view is based on a single table).
▪You cannot alter a table that has a trigger defined on it when the dependent columns are affected.
▪You cannot create a trigger on a system table.
▪You cannot execute triggers that reference dropped or altered objects. To prevent this error:
– Recreate any referenced object that you drop.
– Restore any referenced object you changed back to its original state (known by the trigger).
▪You can use reserved words in trigger statements if they are enclosed in double quotation marks. For example, the following CREATE TRIGGER statement references a column named “data” which is a reserved word.
"CREATE TRIGGER TRIG1 ON TMPT BEFORE INSERT REFERENCING NEW "DATA" AS NEW_DATA BEGIN END"