Archives of the TeradataForum
Message Posted: Wed, 27 Nov 2002 @ 09:15:54 GMT
Subj: | | Re: Macros and Stored Procedures |
|
From: | | Narayan Murthy K S |
Yes, Stored Procedures are the way for such circumstances when you have multiple statements and if you want the locks to be applied for
every statement and if you want to include some programming logic into it.
If you want to retain atomicity and have all your statements executed or rolled back, and if these statements needs new values to be
supplied to them every time they are executed then macros -holds good.
- Narayan.
|