Archives of the TeradataForum

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

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

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>>