commit transaction

Description

Commits the work resulting from the current transaction.

Syntax

commit transaction {transaction_name}

Parameters

transaction_name

is the name assigned to the transaction. It must conform to the rules for identifiers that are described in the Sybase SQL Server Reference Manual.

Examples

Example 1

commit transaction

Usage

• The DB2 access service accepts this statement and translates it to the DB2 commit statement.

• If a transaction is not currently active, this statement has no effect.

• In sybase mode, transaction_name is stripped from the statement before it is passed on the target.

• The DB2 access service converts both commit transaction transaction_name and commit transaction without a transaction name to a commit statement.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF