Archives of the TeradataForum
Message Posted: Fri, 30 Aug 2013 @ 08:57:06 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|