 |
 |
Archives of the TeradataForum
Message Posted: Thu, 20 May 2004 @ 12:04:49 GMT
| Subj: | | Re: Stored Procedure vs. Macro |
| |
| From: | | Glen Blood |
Macros will return data and certain sql statements cannot be used in procedures. In addition, a macro can be used to run a multi-statement
insert-select and is a single transaction. There is also supposed to be a performance gain.
Otherwise, you are correct, stored procedures are extremely powerful. I have fallen in love with Dynamic DDL. We are slowly moving a lot of
UNIX bteq scripts into stored procedures.
Glen
| |
