Example: Using a Trigger to Update a NoPI Table - Advanced SQL Engine - Teradata Database

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