Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Macro vs Multi statement request in teradata
From:   Dave Wellman


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)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020