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