Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

Sybase ASE - Transactions

This article describes transactions in Sybase Adaptive Server Enterprise (ASE) 15.x and earlier.

Transactions

In Sybase ASE, transactions are explicit by default. This means that each SQL statement is not a part of a logical transaction by default, and it is committed on completion.

To start a transaction in Sybase ASE, you have to run BEGIN TRANSACTION (or BEGIN TRAN) statement. The transaction ends with a corresponding COMMIT TRANSACTION (or COMMIT TRAN) or ROLLBACK TRANSACTION (or ROLLBACK TRAN) statements.

Applications (JDBC, ODBC i.e.) can set Autocommit off to use implicit transactions, and to not commit each statement on completion.

Sybase - Transactions in Other Databases

Database Transactions Notes
Oracle Oracle Transactions Transactions are implicit by default - not automatically committed
SQL Server SQL Server Transactions The same behavior


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

sqlways/sybase/transactions.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement