Here’s how to use isolate() function.
Description:
Define transaction isolation level for the connection according to the option and return the original level.
Syntax:
db.isolate()
Note:
The function sets transaction isolation level for the connection according to the option and returns the original level, i.e. its corresponding character of the option. Establish the connection via JDBC by default if no option is used.
Option:
|
@ncurs |
Correspond to NONE,READ_COMMITTED,READ_UNCOMMITTED,REPEATABLE_READ,SERIALIZABLE respectively |
Parameter:
|
db |
Database connection |
Return value:
The original level of the database connection
Example:
|
|
A |
|
|
1 |
=connect("demo") |
|
|
2 |
=A1.isolate@r() |
Set transaction isolation level as REPEATABLE_READ and return the original level " c". |
Related functions: