commit transaction (Transact-SQL only)

Marks the ending point of a user-defined transaction.

Syntax

commit [tran[saction] | work][transaction_name]

Parameters

transaction_name – is the name assigned to the transaction. It must conform to the rules for identifiers. Use transaction names only on the outermost pair of nested begin transaction/commit or begin transaction/rollback statements.

Usage

The access service strips the transaction_name from the statement before passing it to the target.
transaction_name is not used with version 10.5 of Adaptive Server/CIS.
The commit command is not recognized by ODBC, so the DirectConnect Server traps this statement and monitors the transaction state internally. When a commit is issued after a begin transaction, SQL Transact() is called.
Only one transaction can be open for each connection.

Parent topic: Transact-SQL Commands

Created November 29, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com