CREATE TRIGGER TRIGGER_NAME
AFTER INSERT ON TABLE1
FOR EACH ROW MODE DB2SQL
UPDATE TABLE1 SET FIELDC = FIELDA || FIELDB,
FIELDD = CURRENT DATE
WHERE FIELDC IS NULL OR FIELDD IS NULL
AFTER INSERT ON TABLE1
FOR EACH ROW MODE DB2SQL
UPDATE TABLE1 SET FIELDC = FIELDA || FIELDB,
FIELDD = CURRENT DATE
WHERE FIELDC IS NULL OR FIELDD IS NULL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货