Difference between revisions of "TXNISOLATION()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (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== | ||
TXNISOLATION() | TXNISOLATION() | ||
− | |||
==See Also== | ==See Also== | ||
[[SQL BEGIN TRANSACTION|BEGIN TRANSACTION]], [[COMMIT]], [[COMPLETED()]], [[SQL END TRANSACTION|END TRANSACTION]], [[RESET IN]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]], [[SET TRANSACTION]], [[TXNLEVEL()]] | [[SQL BEGIN TRANSACTION|BEGIN TRANSACTION]], [[COMMIT]], [[COMPLETED()]], [[SQL END TRANSACTION|END TRANSACTION]], [[RESET IN]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]], [[SET TRANSACTION]], [[TXNLEVEL()]] | ||
− | |||
==Description== | ==Description== | ||
Line 20: | Line 17: | ||
* READ COMMITTED | * READ COMMITTED | ||
* READ UNCOMMITTED | * READ UNCOMMITTED | ||
− | |||
==Example== | ==Example== | ||
Line 27: | Line 23: | ||
cTrans = txnisolation() | cTrans = txnisolation() | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Latest revision as of 11:22, 12 December 2012
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
Lianja, Lianja Server