Archives of the TeradataForum

Message Posted: Wed, 04 Aug 2004 @ 20:48:08 GMT

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

Here's a few points of difference. Thanks, --Carrie

MACRO

Supports parameterized SQL
Has very limited procedural logic
Can return multi-row answer set(s) for same request
Is transformed into a multi-statement request
Multiple single-row statements are parallelized
Text is in the dictionary
Can explain a macro
May be invoked by a trigger

STORED PROCEDURE

Supports parameterized SQL
Supports sophisticated logic
Returns a single set of values only
One request per statement within the Stored Procedure
Each statement is processed individually, serially
Text is in the user database
Must explain each SQL
Can not be invoked by a trigger

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