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