Properties

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:

SQL

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