Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Oct 2001 @ 18:45:58 GMT


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


Subj:   Re: Posting Oracle trigger to Teradata
 
From:   Fred Pluebell

Rita Yung wrote:

  Are you implying that Teradata doesn't support stored procedure syntax [in a trigger]?  



Teradata triggers are more like a special form of Macro than a Stored Procedure.

From the V2R4 manual:

SQL_procedure_statement [specifies] one or more of the following triggered action statements:

o ABORT/ROLLBACK

o DELETE

o INSERT

o INSERT SELECT

o UPDATE

o A macro containing any combination (including none) of these valid statements can also be executed in a trigger.


Triggered action statements cannot act on the subject table because they cannot be recursive. Cascading triggers are bound by the same rule.



  Can I have multiple triggers defined for the same event?  


Yes; you declare ORDER values to control execution sequence.



  Otherwise, can a trigger call a macro?  


Yes, subject to the restrictions above. But note that macros don't support conditional processing (IF/END-IF) or cursor processing (SELECT _INTO) so that may not help in your situation.



  Can a trigger call a stored procedure?  


No.



     
  <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