The following CREATE TRIGGER request creates a statement trigger that does an INSERT … SELECT of the values represented by a and b from the OLD_TABLE transition table (aliased as myold ) into NoPI table nopi008_t999 whenever NoPI table nopi008_ti is updated.
CREATE TRIGGER nopi008_trig4 AFTER UPDATE ON nopi008_t1 REFERENCING OLD_TABLE AS myold FOR EACH STATEMENT ( INSERT INTO nopi008_t999(a,b) SELECT a,b FROM myold;);