SQL$HELP72.HLB  —  CREATE  TRIGGER  Format
  (B)0CREATE TRIGGER qq> <trigger-name> qqqqqqk                             
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                             
  mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk                             
    mq> STORED NAME IS <stored-name> qqqj x                             
  lqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqj                             
  mwq> BEFORE qwqwq> INSERT qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk         
   mq> AFTER qqj tq> DELETE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x         
                 mq> UPDATE qqwqqqqqqqqqqqqqqqqqqqqqqqqqqwqqj x         
                              mqq> OF qw> <column-name> wj    x         
                                       mqqq , <qqqqqqqqqj     x         
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj         
  mq> ON <table-name> wqqqqqqqqqqqqqqqqqqqqqqqwwq> triggered-action qw> 
                      mq> referencing-clause qjmqqqqqqqqqq<qqqqqqqqqqj  
                                                                        

  (B)0referencing-clause =                                      
                                                            
  REFERENCING qwwq> OLD AS qq> <old-correlation-name> qwwq> 
               xmq> NEW AS qq> <new-correlation-name> qjx   
               mqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqj   
                                                            

  (B)0triggered-action =                                              
                                                                  
  qqwqqqqqqqqqqqqqqqqqqqqqwq> ( qw> triggered-statement qwq> ) qk 
    mq> WHEN (predicate) qj      tqqqqqqqqqqq , <qqqqqqqqu      x 
                                 mqqqqqqqqqqq ; <qqqqqqqqj      x
     lqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
     mqwqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq> 
       tq> FOR EACH ROW qqqqqqqqu                                 
       mq> FOR EACH STATEMENT qqj                                 

  (B)0triggered-statement =        
                               
  qqwq> call-statement qqqwqq> 
    tq> delete-statement qu    
    tq> ERROR qqqqqqqqqqqqu    
    tq> insert-statement qu
    tq> signal-statement qu
    tq> trace-statement qqu
    mq> update-statement qj      
Close Help