|
|
Archives of the TeradataForum
Message Posted: Thu, 29 Aug 2013 @ 12:23:25 GMT
Subj: | | Re: Macro vs Multi statement request in teradata |
|
From: | | Dieter Noeth |
Sughesh.Sumansingh wrote:
| Only difference is, in MSR you are using BT - ET (explicit). Macro is MSR implicitly. | |
No, a MSR is not using BT/ET, it's just multiple statements sent to the parser as a single request.
| Other difference is, in BT - ET you can have one DDL inside, when it is last one. but inside macro DDL statements are not
allowed. | |
No, you *can* use DDL, but only on its own, no other statements allowed.
Dieter
| |