新增记录时更新其它表
CREATE TRIGGER DATARECORD.tri_T_501insert
AFTER
INSERT
ON
DATARECORD.T_501
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
BEGIN
ATOMIC
UPDATE
DB2ADMIN.T_SENSOR_NEW
SET
FD_VALUE = N.value,
FD_TIME = N.time
WHERE
FD_TAG_NAME = N.name
AND (FD_TIME IS NULL
OR FD_TIME < N.time ) ;
END
字段值更新时插入记录
DROP TRIGGER DB2ADMIN.tri_T_baseinfo_update;
CREATE TRIGGER DB2ADMIN.tri_T_baseinfo_update
AFTER UPDATE OF FD_ICON ON DB2ADMIN.T_BASEINFO
REFERENCING NEW AS N
OLD AS O
FOR EACH ROW MODE DB2SQL
BEGIN
ATOMIC
INSERT INTO DB2ADMIN.T_BASE_STATE_LOG (FD_ICON, FD_BASEID) VALUES(N.FD_ICON, N.FD_ROWID);
END;
评论区