Archives of the TeradataForum

Message Posted: Fri, 30 Aug 2013 @ 08:57:06 GMT

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

Hi,

You can't use BT/ET in an ANSI session. Even in ANSI mode, a macro is still an MSR.

You have three transaction start/end rules:

1. ANSI mode: the first request starts the transaction which continues until you COMMIT or logoff. If you logoff without a COMMIT then th etransaction is rolle dback.

2. Teradata (or BTET) mode implicit transaction: each request is a separate transaction. If the request contains multiple statements (MSR) or the request is an EXECUTE macro command then all statements are part of the same request and therefore form a single transaction.

3. Teradata (or BTET) mode explicit transaction: the transaction is started using BT and is terminated by a failure, ET command or logoff. Again, if you logoff without ending the transaction it is rolled back.

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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