Archives of the TeradataForum
Message Posted: Thu, 29 Aug 2013 @ 10:25:45 GMT
Macro deals all statements inside as MSR. So when any one statement fails in between everything above will get rollback automatically.
Only difference is, in MSR you are using BT - ET (explicit). Macro is MSR implicitly.
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.
Hope it is clear to you.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|