Difference between revisions of "TXNISOLATION()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions 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
Line 34: Line 30:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 16:04, 5 November 2009

Purpose

Function to return the current Transaction Isolation Level setting


Syntax

TXNISOLATION()


See Also

BEGIN TRANSACTION, COMMIT, COMPLETED(), END TRANSACTION, RESET IN, ROLLBACK, ROLLBACK(), SET ROLLBACK, SET TRANSACTION, TXNLEVEL()


Description

The TXNISOLATION() function returns the current Transaction Isolation 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;
cTrans = txnisolation()


Products

Recital, Recital Server