 |
 |
Archives of the TeradataForum
Message Posted: Tue, 10 Sep 2002 @ 08:34:59 GMT
| Subj: | | Re: Macro to loop thru different databases |
| |
| From: | | Dieter N�th |
| | It IS a multistatement request, because EVERY macro is a multistatement request, just look at EXPLAIN. | |
| | Well, I did look at the EXPLAIN, and it's different from what I thought was a multistatement request. | |
The explain is supposed to be the same, no matter if you explain exec macro or the statements inside the Macro.
A multistatement request is parsed and optimized as a single unit of work. When run in Teradata Mode (without BT) it's an implicit
transaction. A macro is parsed and optimized as a single unit of work. When run in Teradata Mode (without BT) it's an implicit
transaction.
Dieter
| |
