不好意思,我刚用DB2,还不太清楚
CREATE TRIGGER inserter_con AFTER insert ON TB_USER_CONTACT_CHART REFERENCING NEW AS N_ROW FOR EACH ROW MODE DB2SQL BEGINATOMIC DECLARE ip_address VARCHAR (50); SELECT APPL_ID FROM TB_USER_CONTACT_CHART(SNAPSHOT_APPL_INFO('SAMPLE',-2))as ip_address; IF ip_address= '192.168.0.151' then VALUES(rundb('TB_USER_CONTACT_CHART',N_ROW.PROJECT_ORDER||'>'||N_ROW.USER_NO,'insertdb2'));END IF;END
我这样用到我的触发器中?