Archives of the TeradataForum

Message Posted: Mon, 04 Aug 2008 @ 06:12:22 GMT

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

Hi Sadashiv,

You Can Identify the Procedures which are in ANSI or TD Mode based on some specific commands like

"COMMIT AND ROLLBACK" Which are not present in TD mode

Its auto commit in TD Mode so no need to use..

So according to Anomy first get that procedure as "show procedure proc_name"

And check it for commit or rollback statements .

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