Archives of the TeradataForum

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

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

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

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.

No.

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