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