db2 CREATE trigger
db2 CREATE trigger
--监控某个表，当数据插入到表后，执行触发。
www.2cto.com
CREATE trigger tri_ins_UB_ORGINFO
after INSERT ON UB_ORGINFO
--for insert
REFERENCING NEW AS n
FOR EACH ROW --MODE DB2SQL
BEGIN ATOMIC
delete from UB_ORGINFO_HK;
insert into UB_ORGINFO_HK (
SELECT I_ID as ibankid, S_DISPLAYNAME as SBANKNAME,PBCBIGAREABANK as sbanktype
FROM UB_ORGINFO
WHERE -- BUSINESSCATEGORY !='1' AND
I_STATUS=1
AND S_DN IS NULL AND PBCBIGAREABANK=276
AND PBCBIGAREABANK IS not NULL) ;
end
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。