db2触发器
--TRIG_ARTICLE_ADDARTICLEFOLDERCREATE TRIGGER TRIG_ADD_EFOLDER
NO CASCADE BEFORE INSERT ON ARTICLEFOLDER
REFERENCING NEW AS articlef
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
DECLARE temp_id double;
SET temp_id = NEXTVAL FOR SEQ_ARTICLEFOLDER;
SET articlef.CLASSID = temp_id;
SET articlef.ORDERLINE = temp_id;
END;
--TRIG_SURVEY_QUEDEL
CREATE TRIGGER TRIG_SURVEY_QUEDEL
AFTER DELETE ON SURVEYQUESTIONS
REFERENCING OLD AS OLD
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
DELETE FROM SURVEYANSWERS WHERE QUE_ID = OLD.QUE_ID;
DELETE FROM SURVEYLOGSCOOKIE WHERE QUE_ID = OLD.QUE_ID;
DELETE FROM SURVEYLOGSIP WHERE QUE_ID = OLD.QUE_ID;
END;
--TRIG_SURVEY_SKDEL
CREATE TRIGGER TRIG_SURVEY_SKDEL
AFTER DELETE ON SURVEYQUESTIONS_KIND
REFERENCING OLD AS OLD
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
DELETE FROM SURVEYQUESTIONS WHERE SK_ID = OLD.SK_ID;
END;
页:
[1]