Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Apr 2005 @ 20:24:07 GMT


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


Subj:   BEFORE trigger
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, April 08, 2005 16:15 -->

I got the follow message when trying to create a trigger.

     *** Trigger has been created.
      *** Warning: 5851 BEFORE triggers having data changing statements are not supported in V2R5.1.
      *** Total elapsed time was 1 second.

I read documentation about the warning and was confused. My understanding of what I read is that the following type of trigger would be alright once we move to v2r5.1 or am I wrong.

     CREATE TRIGGER a.TRG
     BEFORE DELETE ON  a.A
         REFERENCING OLD AS beforerow
         FOR EACH ROW
     WHEN (beforerow.col1 > 0)
     (INSERT INTO  a.b
     VALUES(
           beforerow.col1,
           beforerow.col2,
           beforerow.col3,
       ););

      *** Trigger has been created.
      *** Warning: 5851 BEFORE triggers having data changing statements are not supported in V2R5.1.
      *** Total elapsed time was 1 second.

Thanks in advance.



     
  <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