|
|
Archives of the TeradataForum
Message Posted: Wed, 11 Sep 2002 @ 20:48:15 GMT
Subj: | | Re: Transactions, requests, statements, macros |
|
From: | | Geoffrey Rommel |
| But you still don't believe me that a macro is treated the same as a multistatement ;-) | |
| When the PE parses a multistatement it's resolved to an initial parse tree and then passed to the optimizer. When the PE parses a
macro it's resolved to an initial parse tree and then passed to the optimizer. | |
| It's just like using a view vs. submitting the view's source code. | |
Yes! This makes sense to me. And sure enough, I found a passage in the manual confirming this:
The following are examples of kinds of multistatement requests:
- Explicit BT/ET transactions
- Macros
--SQL Reference (V2R4.1), Vol. 1, p. 1-19 (PDF p. 33)
| |