DB2
サンプル ====== CREATE OR REPLACE TRIGGER TRG_HOGE NO CASCADE BEFORE UPDATE OR INSERT ON HOGE_TABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN IF INSERTING THEN SET NEW.CREATE_DATE = CURRENT TIMESTAMP ; SET NEW.UPDATE_DATE = CURR…
サンプル ====== CREATE OR REPLACE TRIGGER TRG_HOGE NO CASCADE BEFORE UPDATE OR INSERT ON HOGE_TABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN IF INSERTING THEN SET NEW.CREATE_DATE = CURRENT TIMESTAMP ; SET NEW.UPDATE_DATE = CURR…