Archives of the TeradataForum
Message Posted: Tue, 26 Feb 2008 @ 21:22:06 GMT
The complex answer is it depends. The simple answer is that most likely your tool will not use the transaction API's (mentioned below) and each request will be committed upon completion.
JDBC (and ODBC and other connectivity mechanisms) provides API's to manage transactions.
In Java, you should look at java.sql.Connection.setAutoCommit (), java.sql.Connection.commit () and java.sql.Connection.rollback ()
The java docs for setAutoCommit say that by default connections will be in auto commit mode.
Depends upon the above. In the default commit mode (i.e. auto commit = true), BT and ET appear to be ignored.
Well you could use the API's mentioned above. Other options include multi-statement requests and macros.
Hope this helps
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|