db2 CREATE trigger

--监控某个表，当数据插入到表后，执行触发。

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
  
---------------------