实际业务需求是这样的:在一些业务中常用的基本表修改时没有履历记录,查问题时比较麻烦。
在Table上创建rule / 触发器可以解决此问题,在实际操作中会有一个问题
以 m_ope_d为例:
--记录m_ope_d insert履历
create rule rule_insert_m_ope_d as on
insert to m_ope_d do also insert into m_ope_d_log( oprtype, oprtime,ope_key, unq_seq_id, etl_timestamp, etl_event_node, etl_event_name, etl_evt_seq_id, ope_id, ope_ver, ope_dsc, shop_key_fk, shop_id, proc_id, eqpt_gp_key_fk, eqpt_gp_id, eqpt_run_mode, ope_seq_no, pep_lvl, up_load_id, dn_load_id, wk_cent_id, wk_cent_dsc, evt_cate, evt_user, evt_timestamp, evt_note, ope_type, mes_ope_flg, ope_proc_type, ope_def_format, ext_dept, ext_type, ext_sub_dept, valid_flg, group_name )
values('insert',current_timestamp(6), new.ope_key, new.unq_seq_id, new.etl_timestamp, new.etl_event_node, new.etl_event_name, new.etl_evt_seq_id, new.ope_id, new.ope_ver, new.ope_dsc, new.shop_key_fk, new.shop_id, new.proc_id, new.eqpt_gp_key_fk, new