InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 21:28:15 GMT20http://www.teradata.com/teradataforum/Topic11139-1-1.aspxThanks a lot Mr.Dieter..Tue, 08 Apr 2008 04:20:10 GMTravindrareddyhttp://www.teradata.com/teradataforum/Topic11139-1-1.aspxHi 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.DieterSat, 05 Apr 2008 09:24:09 GMTdnoethhttp://www.teradata.com/teradataforum/Topic11139-1-1.aspxHi 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,RavindraFri, 04 Apr 2008 05:31:11 GMTravindrareddy