Template code

CREATE TRIGGER tr_check_req
AFTER INSERT ON HW3.SCHEDULE
REFERENCING NEW AS nROW
FOR EACH ROW MODE DB2SQL
WHEN ()
BEGIN ATOMIC
SIGNAL SQLSTATE '88888' ('Student does not have prerequisite OR co-requisite');
END