Kbase P114994: How to set the Transaction Isolation Level in ESQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/1/2009 |
|
Status: Verified
GOAL:
How to set the Transaction Isolation Level in ESQL-92?
GOAL:
Where to set the Transaction Isolation Level in ESQL-92?
GOAL:
Can the "SET TRANSACTION ISOLATION LEVEL" statement be used with embedded SQL-92
GOAL:
Can the "SET TRANSACTION ISOLATION LEVEL" statement be used with ESQL/C?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
FIX:
Progress SQL-92 does support the SET TRANSACTION ISOLATION LEVEL statement in embedded SQL-92 to make the client-side SQL-92 application always aware of transaction characteristics.
Example:
EXEC SQL SET TRANSACTION ISOLATION LEVEL isolation_level_name
Supported Isolation Levels:
READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE