Archives of the TeradataForum

Message Posted: Thu, 29 Aug 2013 @ 10:25:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Dipti,

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.

Thanks,

Sughesh.

	<Prev	Next>		<<First	<Prev	Next>	Last>>