Kbase P125791: SQL: How to set the connection TRANSACTION ISOLATION LEVEL from the SQL Editor of the DB Navigator i
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/28/2011 |
|
Status: Verified
GOAL:
SQL: How to set the connection TRANSACTION ISOLATION LEVEL from the SQL Editor of the DB Navigator in Architect?
GOAL:
How to set the TRANSACTION ISOLATION LEVEL in the DB Navigator Perspective of the OpenEdge Architect?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2x
FIX:
Use the following syntax to set the Transaction Isolation Level of the connection:
SET TRANSACTION ISOLATION LEVEL isolation_level_name ;
Where isolation_level_name is one of the following strings:
READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE
For example, executing the following command from the SQL Editor sets the connection's TRANSACTION ISOLATION LEVEL to READ UNCOMMITTED:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
And executing the following command from the SQL Editor sets the connection's TRANSACTION ISOLATION LEVEL to READ COMMITTED:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;