Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Aug 2000 @ 16:37:39 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Trigger question
 
From:   Fred Pluebell

The syntax for row triggers has ambiguous semantics - see DR45997 in the V2R3.0.3 Release Summary (B035-1068-039K). In V2R3.0.3 and later, attempting to create this trigger would fail with code 5529. From the V2R4 messages manual, the corresponding message is:

A triggered statement inside a row trigger can not refer to a table that is being changed by the row trigger.

Rewrite it as a statement trigger and it will work:

     REPLACE TRIGGER TEST.XXXXX ENABLED
     BEFORE DELETE ON TEST.TABLEA
       REFERENCING OLD_TABLE AS DELETEROWS
       FOR EACH STATEMENT
     (DELETE FROM TEST.TABLEB WHERE COLB IN (SELECT COLB FROM DELETEROWS););


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023