Open topic with navigation
In NuoDB SQL, the default transaction mode is implicit. Each Data Manipulation Language (DML) statement starts its own transaction and is automatically committed or rolled back. If the statement executes successfully then the transaction is committed. If the statement fails then the transaction is rolled back. The benefit of an implicit transaction is that you do not need to specify
NuoDB SQL also supports explicit transactions. Specify the
START TRANSACTION and
ROLLBACK statements to use an explicit transaction. The benefit of an explicit transaction is that the transaction is user defined and you can commit or roll back a batch of DML statements as one transaction.
See the following topics: