Marks the ending point of a user-defined transaction.
commit [tran[saction] | work][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.
commit transaction
The access service strips the transaction_name from the statement before passing it on the target.
transaction_name is not used with version 10.5 of ASE/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.
