Differences between Macro and Stored procedue

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Differences between Macro and Stored procedue...

Rate Topic

Display Mode

Topic Options

Author

Message

kiran parsha

Posted 6/26/2009 3:41:18 PM

Junior Member

Group: Forum Members
Last Login: 11/1/2009 1:22:16 PM
Posts: 15, Visits: 77

Hi,

Can any one please tell me the differences between a Macro and Stored procedue as both contains set of sql statements.

Regards,
kiran

Post #15931

Adeel.Chaudhry

Posted 6/28/2009 11:15:18 PM

Supreme Being

Group: Forum Members
Last Login: 10/18/2009 5:48:26 AM
Posts: 273, Visits: 1,214

Hello,

Following are few differences between MACRO and Stored-Procedure:

MACRO:
- Limited procedural logic
- Can return multi row answer sets for the same request
- Multi-statement request parallelizes multiple single row statements
- Can EXPLAIN a macro
- Can be invoked by a trigger

Stored Procedure
- Sophisticated procedural logic
- Returns a single set of values (Before Teradata 12)
- One request per individually processed statement
- Cannot EXPLAIN a stored procedure. Instead, must EXPLAIN each individual stored procedure SQL statement individually
- Cannot be invoked by a trigger

HTH!

Regards,

Adeel

Post #15939

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:23pm