db2触发器

luoyahu

 
 
--TRIG_ARTICLE_ADDARTICLEFOLDERCREATE TRIGGER TRIG_ADD_EFOLDERNO CASCADE BEFORE INSERT ON ARTICLEFOLDERREFERENCING NEW AS articlefFOR EACH ROW MODE DB2SQLBEGIN ATOMICDECLARE temp_id double;SET temp_id = NEXTVAL FOR SEQ_ARTICLEFOLDER;SET articlef.CLASSID = temp_id; SET articlef.ORDERLINE = temp_id;END; 
--TRIG_SURVEY_QUEDELCREATE TRIGGER TRIG_SURVEY_QUEDELAFTER DELETE ON SURVEYQUESTIONSREFERENCING OLD AS OLDFOR EACH ROW MODE DB2SQLBEGIN ATOMICDELETE 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_SKDELCREATE TRIGGER TRIG_SURVEY_SKDELAFTER DELETE ON SURVEYQUESTIONS_KINDREFERENCING OLD AS OLDFOR EACH ROW MODE DB2SQLBEGIN ATOMICDELETE FROM SURVEYQUESTIONS WHERE SK_ID = OLD.SK_ID;END;