触发器

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;