Archives of the TeradataForum
Message Posted: Thu, 11 Oct 2001 @ 18:45:58 GMT
Rita Yung wrote:
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 INSERT SELECT
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.
Yes; you declare ORDER values to control execution sequence.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|