IBM DB2 Triggers

The following triggers are available in the database.

Trigger

Name: TRG_SUB_INSERT

Content:

CREATE TRIGGER TRG_SUB_INSERT NO CASCADE BEFORE INSERT ON SUBSCRIPTION REFERENCING NEW AS INSERTED FOR EACH ROW MODE DB2SQL BEGIN ATOMIC IF EXISTS (SELECT * FROM SUBSCRIPTION WHERE code = inserted.code) THEN SIGNAL SQLSTATE '50005' SET MESSAGE_TEXT = 'The subscription code is already in the subscription table'; END IF; END !