Archives of the TeradataForum

Message Posted: Mon, 26 Nov 2007 @ 22:59:54 GMT

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

Te set of statements will hold locks after each statements in BT ET mode until it encounters ET. so this might be the reason for your error.

you can refer to below statement in RDBMS SQL reference for better understanding.

Although you can enter a multistatement operation interactively using an explicit transaction (either BT/ET or COMMIT), a better practice is to define such an operation as a macro because an explicit transaction holds locks placed on objects by statements in the transaction until the statement sequence is completed with an END TRANSACTION or COMMIT statement.

Hope this help.

Thanks,

Vijay

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