Home Page for the TeradataForum
 
https:

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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020