db2触发器

最新推荐文章于 2023-10-08 10:30:10 发布

iteye_4941

最新推荐文章于 2023-10-08 10:30:10 发布

阅读量185

点赞数

CC 4.0 BY-SA版权

分类专栏： database 文章标签： DB2

本文链接：https://blog.youkuaiyun.com/iteye_4941/article/details/81751645

database 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了数据库中触发器的设计与应用案例，包括文章文件夹的创建触发器及问卷删除时的相关联删操作触发器。通过具体SQL语句展示了如何在不同场景下使用触发器来维护数据一致性和完整性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--TRIG_ARTICLE_ADDARTICLEFOLDER
CREATE 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;