Archives of the TeradataForum
Message Posted: Fri, 30 Aug 2013 @ 16:24:29 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|