Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Federal Information Processing Standards (FIPS) flagger [Table of Contents] Identifiers

Transact-SQL User's Guide

[-] Chapter 1 SQL Building Blocks
[-] Compliance to ANSI standards
[-] Chained transactions and isolation levels

Chained transactions and isolation levels

Adaptive Server provides SQL standard-compliant "chained" transaction behavior as an option. In chained mode, all data retrieval and modification commands (delete, insert, open, fetch, select, and update) implicitly begin a transaction. Since such behavior is incompatible with many Transact-SQL applications, Transact-SQL style (or "unchained") transactions remain the default.

You can initiate chained transaction mode using the set chained option. The set transaction isolation level option controls transaction isolation levels. See Chapter 18, "Transactions: Maintaining Data Consistency and Recovery," for more information.

Federal Information Processing Standards (FIPS) flagger [Table of Contents] Identifiers