Figure 6

Column-level trigger using the SIGNAL statement

CREATE TRIGGER salarycheck
BEFORE UPDATE ON emp
REFERENCING NEW AS n
FOR EACH ROW MODE DB2ROW
BEGIN
DECLARE maxsalary INTEGER;
SET maxsalary = (SELECT max(salary) FROM
jobdescript