FrontBase Documentation

Backtrack:
  Welcome!
    5. SQL 92
      5.4. FrontBase Extensions
Updated: 20-Nov-2000
prev — next
Table of Contents

5.4.5. Transaction Management

SET TRANSACTION ISOLATION LEVEL VERSIONED;

In addition to the isolation levels defined by SQL 92, FrontBase supports an isolation level called VERSIONED. This level is ideal for the situation where many users are fetching from the database and where only a few users update the database. Users who only fetch rows will never have to wait for an update to complete. They will, instead, get the data as they existed prior to the start of the update. Once an update has been successfully committed, the updates are available as the next version.
The SET TRANSACTION statement has also been extended with a locking discipline option:

SET TRANSACTION LOCKING REALISTIC | OPTIMISTIC | PESSIMISTIC;

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!