Difference between revisions of "TXLEVEL()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the current Transaction Isolation Level setting | Function to return the current Transaction Isolation Level setting | ||
− | |||
==Syntax== | ==Syntax== | ||
TXLEVEL() | TXLEVEL() | ||
− | |||
==See Also== | ==See Also== | ||
− | [[CLOSE | + | [[CLOSE]], [[DECLARE CURSOR]], [[DROP CURSOR]], [[FETCH]], [[OPEN]], [[SQL SELECT|SELECT]], [[SET TRANSACTION]], [[TXNISOLATION()]], [[TXNLEVEL()]] |
− | + | ||
==Description== | ==Description== | ||
Line 20: | Line 17: | ||
* (READ) COMMITTED | * (READ) COMMITTED | ||
* (READ) UNCOMMITTED | * (READ) UNCOMMITTED | ||
− | |||
==Example== | ==Example== | ||
Line 29: | Line 25: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] |
Latest revision as of 06:20, 10 February 2012
Contents
Purpose
Function to return the current Transaction Isolation Level setting
Syntax
TXLEVEL()
See Also
CLOSE, 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