CREATE TRIGGER LIB.TABLEINS
AFTER INSERT ON LIB.TABLE
REFERENCING NEW AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'INSERT', CURRENT TIMESTAMP);
END;
1.创建触发器以跟踪更新:
CREATE TRIGGER LIB.TABLEUPD
AFTER UPDATE ON LIB.TABLE
REFERENCING NEW AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'UPDATE', CURRENT TIMESTAMP);
END;
1.创建触发器以跟踪删除:
CREATE TRIGGER LIB.TABLEDEL
AFTER DELETE ON LIB.TABLE
REFERENCING NEW AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'DELETE', CURRENT TIMESTAMP);
END;
CREATE TRIGGER LIB.TABLEDEL
AFTER DELETE ON LIB.TABLE
REFERENCING**OLD**AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'DELETE', CURRENT TIMESTAMP);
END;
3条答案
按热度按时间relj7zay1#
您是否启用了日志功能并捕获了映像前后的信息?如果是,您可以从日志中获取与数据更改相关的所有信息。
ldxq2e6h2#
我认为触发器最适合您。请注意,系统将需要投入资源来跟踪这些,所以请让您的系统操作员知道!。
我会这么做:
1.创建要跟踪其更改的文件的副本:
1.为操作和日期时间添加列:
1.创建触发器以跟踪插入:
1.创建触发器以跟踪更新:
1.创建触发器以跟踪删除:
1.编辑:通过插入、更新和删除来测试并确保一切都正常工作!
如果有帮助,请告诉我!
yrwegjxp3#
删除的触发器需要引用OLD而不是NEW。