Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Aug 2013 @ 16:24:29 GMT


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


Subj:   Re: Macro vs Multi statement request in teradata
 
From:   Dempsey, Mike

Although Dave is correct on the details of transactions, some of the interface products will automatically commit each request even when using ANSI mode. As a result you may have to use interface or application specific transaction control commands.

If you are writing your own application then you must use the facility provided by the interface you are using to specify the start and end of the transaction. Otherwise each request will be auto committed.

If you are using ANSI mode in SQL Assistant and you want to create a transaction consisting of multiple statements you will need to add the .BeginTx command before the first statement and .CommitTx after the last statement.

These are SQL Assistant specific commands that allow you to override the automatic commit that would normally be performed by the .Net provider or by ODBC. (Note that this feature was first introduced in version 14.01) Eg.

     .BeginTx
     Insert into ... ;
     Update ... ;
     .CommitTx

Mike Dempsey



     
  <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: 23 Jun 2019