why Stored Procedure saved in Permanent Space ? Why not Macro?

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.

why Stored Procedure saved in Permanent Space...

Rate Topic

Display Mode

Topic Options

Author

Message

ravindrareddy

Posted 4/4/2008 5:31:11 AM

Forum Newbie

Group: Forum Members
Last Login: 6/10/2008 5:26:30 AM
Posts: 9, Visits: 24

Hi All,

Can any one tell me why stored procedure saved in Perm space, but Macro is not saved in perm space...

As both are doing the same job why they r not saved in the same place....

Any clue?

Regards,
Ravindra

Learn And Share...

URS

Ravindra Red

Post #11139

dnoeth

Posted 4/5/2008 9:24:09 AM

Supreme Being

Group: Forum Members
Last Login: Today @ 7:20:23 AM
Posts: 533, Visits: 282

Hi Ravindra,
a macro is just source code like a view, whereas a SP is rewritten by the PE as a kind of embedded SQL program in C and then compiled to a Shared Object (Unix) or DLL (Windows) with a single exported function. That SO/DLL is stored within the database and when you CALL the SP, it's materialized within file system and the exported function is called.

Dieter

Post #11156

ravindrareddy

Posted 4/8/2008 4:20:10 AM

Forum Newbie

Group: Forum Members
Last Login: 6/10/2008 5:26:30 AM
Posts: 9, Visits: 24

Thanks a lot Mr.Dieter..

Learn And Share...

URS

Ravindra Red

Post #11172

« 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 4:36pm