Name: | TR_STAFF_BEFORE |
Schema: | USER |
Definer: | USER |
Table schema: | USER |
Table: | STAFF |
Valid: | |
Trigtime: | BEFORE |
Trigevent: | DELETE |
Granularity: | ROW |
Create time: | 24.06.2006 |
Qualifier: | USER |
Description: |
CREATE TRIGGER "USER".TR_STAFF_BEFORE NO CASCADE BEFORE DELETE ON "USER".STAFF REFERENCING OLD AS OLDSTAFF FOR EACH ROW MODE DB2SQL
WHEN(oldstaff.job = 'Sales') BEGIN
ATOMIC SIGNAL SQLSTATE '75000' ('Sales staff cannot be deleted... see the DO_NOT_DEL_SALES trigger.');
END
See Also
List of triggers