 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Nov 2010 @ 09:51:58 GMT
| Subj: | | Re: Pros and Cons of Stored Procedures |
| |
| From: | | Faible Mou |
Cesar Ureta wrote:
| | ending up with 5000 line stored procedures that aborted and not being able to figure out what went wrong. | |
Thanks for everyone who responded.
Interesting, no one is mentioning what I was expecting for. I heard some companies are avoiding stored procedures because they only run on
single AMPs. Is that true?
Moreover, are stored procedures like marcos, in the sense that the whole procedure is regarded as a single transaction, and will rollback the
whole thing if anything goes wrong?
Thanks
| |
