Difference between revisions of "TXLEVEL()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
==Class==
 
Transaction Processing
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the current Transaction Isolation Level setting
 
Function to return the current Transaction Isolation Level setting

Latest revision as of 16:52, 28 October 2009

Purpose

Function to return the current Transaction Isolation Level setting


Syntax

TXLEVEL()


See Also

CLOSE, Configuration Files, DECLARE CURSOR, DROP CURSOR, FETCH, OPEN, SELECT, SET TRANSACTION, TXNISOLATION(), TXNLEVEL()


Description

The TXLEVEL() function returns the current Transaction Isolation Level setting. The Transaction Isolation Level is set using the SET TRANSACTION [ISOLATION LEVEL <level>] command.

The Transaction Isolation Level can be any of the following, please see the SET TRANSACTION Set Command for full details:

  • SERIALIZABLE
  • REPEATABLE READ
  • (READ) COMMITTED
  • (READ) UNCOMMITTED


Example

set transaction isolation level read uncommitted
? txlevel()
UNCOMMITTED


Products

Recital Server, Recital