我有下面一个ORACLE触发器,现在要改成DB2的触发器,请问DB2能同时支持UPDATE,INSERT吗?还是我必须要写对应的三个触发器呢?在线等,谢谢大家了。
CREATE OR REPLACE TRIGGER "BRAS".trig_arc_mime_table
AFTER UPDATE OR DELETE OR INSERT ON ARC_MIME_TABLE
FOR EACH ROW
BEGIN
IF INSERTING THEN
DELETE SYS_DATA_DICT
WHERE dict_type='509'
AND dict_code=:NEW.file_extension;
INSERT INTO SYS_DATA_DICT(id,dict_type,dict_code,dict_name,view_index,remark)
VALUES (seq_sys_data_dict.nextval,509,:NEW.file_extension, :NEW.file_type, :NEW.id,'文件类型');
END IF;
IF UPDATING THEN
UPDATE SYS_DATA_DICT s
SET s.dict_code=:NEW.FILE_EXTENSION,
s.dict_name=:NEW.file_type
WHERE s.dict_type=509
AND s.dict_code=:OLD.FILE_EXTENSION;
END IF;
IF DELETING THEN
DELETE FROM SYS_DATA_DICT
WHERE dict_type=509
AND dict_code=:OLD.file_extension;
END IF;
END;
------解决方案--------------------------------------------------------
写对应的三个触发器
------解决方案--------------------------------------------------------
应该是insert update delete 各写一个
------解决方案--------------------------------------------------------
不支持,分开写