http://goo.gl/EmKxy0

Archive

Posts Tagged ‘unchained’

chained and unchained transaction mode

August 12th, 2012 No comments

A chained mode transaction may be thought of as “auto-starting”; when you log in and begin any SQL statement, ASE invisibly begins a transaction which  will continue until you explicitly end it. In this way, you are always making all changes as part of a transaction.

 

In unchained mode, the rule shift in an important manner: while any single data change statement is treated as a transaction, group of statements are not transactions without an explicit command to begin a transaction.