commit

Marks the ending point of a user-defined transaction.

Syntax

commit [tran | transaction | work] [transaction_name]

Parameters

Examples

Usage

  • Define a transaction by enclosing SQL statements and system procedures with the phrases begin transaction and commit. If you set the chained transaction mode, the SAP ASE server implicitly invokes a begin transaction before the following statements: delete, insert, open, fetch, select, and update. You must still explicitly enclose the transaction with a commit.

  • To cancel all or part of an entire transaction, use the rollback command. The begin transaction command must appear within a transaction. You cannot roll back a transaction after the commit has been entered.

  • If no transaction is currently active, the commit or rollback statement has no effect on the SAP ASE server.

Standards

ANSI SQL – Compliance level: Entry-level compliant.

The commit transaction and commit tran forms of the statement are Transact-SQL extensions.

Permissions

No permission is required to use commit.

Related reference
begin transaction
delete
insert
open
fetch
select
update
rollback
save transaction