Trigger Definition Example

Trigger column:

Name

Type

Len

Dec

SALARY

P

12

2

 
Trigger function:

Name

Function

Trigger Before

Points After

Comments

TRGFN1






Open



Call trigger function TRGFN1 following an insert or update of column SALARY, or before a delete of column SALARY. Note that no conditions have been defined for this trigger.






Close



Read



Insert


Y

Update


Y

Delete

Y


Also See

Table Rules & Triggers Development in the Developers Guide for details and examples