SQL Dialects Reference/Transactions

Transactions Start START TRANSACTION[transaction characteristics] Implicit BEGIN [WORK]START [TRANSACTION] commit.html START TRANSACTIONBEGIN TRANSACTION sql-begin.html BEGIN [WORK|TRANSACTION]sql-start-transaction.html START TRANSACTION BEGIN [TRANSACTION] lang_transaction.html Implicit BEGIN TRAN[SACTION] 188929 Implicit SET TRANSACTION Commit COMMIT [WORK] COMMIT [WORK] r0000903.htm COMMIT [WORK] commit.html COMMIT [WORK] [AND [NO] CHAIN] COMMIT [WORK|TRANSACTION] sql-commit.html COMMIT [TRANSACTION]END [TRANSACTION] lang_transaction.html COMMIT [WORK] statements_4010.htm 178628 COMMIT [WORK]190295 COMMIT TRAN[SACTION] [transaction_name] [EXEC SQL] COMMIT [WORK] SQL%20Reference%20Guide/commit.htm COMMIT WORK COMMIT_ROLLBACK.html COMMIT [WORK] Rollback whole transaction ROLLBACK [WORK] ROLLBACK [WORK] r0000992.htm ROLLBACK [WORK] commit.html ROLLBACK [WORK] [AND [NO] CHAIN] ROLLBACK [WORK|TRANSACTION] sql-rollback.html ROLLBACK [TRANSACTION] lang_transaction.html ROLLBACK [WORK] statements_9021.htm 174973 ROLLBACK [WORK]181299 ROLLBACK TRAN[SACTION] [EXEC SQL] ROLLBACK [WORK] SQL%20Reference%20Guide/rollback.htm ROLLBACK WORK COMMIT_ROLLBACK.html ROLLBACK [WORK] Define a savepoint x, while inside a transaction SAVEPOINT x SAVEPOINT x ON ROLLBACK RETAIN CURSORS r0003271.htm SAVEPOINT x savepoint.html SAVEPOINT x SAVEPOINT x sql-savepoint.html SAVE TRAN[SACTION] x 188378 SAVEPOINT x statements_10001.htm SAVEPOINT x SQL%20Reference%20Guide/savepoint.htm SAVEPOINT x lang_savepoint.html SAVEPOINT x Rollback to given savepoint x ROLLBACK [WORK] TO SAVEPOINT x ROLLBACK [WORK] TO SAVEPOINT x r0000992.htm ROLLBACK [WORK] TO [SAVEPOINT] x savepoint.html ROLLBACK [WORK] [AND [NO] CHAIN] TO SAVEPOINT x ROLLBACK [WORK|TRANSACTION] TO [SAVEPOINT] x sql-rollback-to.html ROLLBACK TRAN[SACTION] x 181299 ROLLBACK [WORK] TO [SAVEPOINT] x statements_9021.htm [EXEC SQL] ROLLBACK [WORK] TO x SQL%20Reference%20Guide/rollback.htm ROLLBACK [TRANSACTION] TO [SAVEPOINT] x lang_savepoint.html ROLLBACK [WORK] TO [SAVEPOINT] x Release (forget) savepoint x RELEASE SAVEPOINT x RELEASE [TO] SAVEPOINT x r0003269.htm RELEASE SAVEPOINT x savepoint.html RELEASE SAVEPOINT x RELEASE [SAVEPOINT] x sql-release-savepoint.html RELEASE [SAVEPOINT] x lang_savepoint.html RELEASE SAVEPOINT x Prepare transaction named id for two-phase commit PREPARE TRANSACTION id sql-prepare-transaction.html Commit prepared transaction named id COMMIT PREPARED id sql-commit-prepared.html Rollback prepared transaction named id ROLLBACK PREPARED id sql-rollback-prepared.html |} Start Commit Rollback Prepare Execute prepared Linter Implicit a COMMIT statement is executed any DDL statement is executed any statement is executed in AUTOCOMMIT mode a ROLLBACK statement is executed a user process is terminated abnormally or disconnects without COMMIT/ROLLBACK ? ?