Kbase P113862: What is the equivalent of the 4GL NO-LOCK in SQL-92 when using READ COMMITTED mode?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2009 |
|
Status: Verified
GOAL:
What is the equivalent of the 4GL NO-LOCK in SQL-92?
GOAL:
Is it possible to make dirty-reads in READ COMMITTED mode?
GOAL:
How to read only committed data with a SELECT statement?
GOAL:
When will NO-LOCK will be implemented with a SQL SELECT statement?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1E
OpenEdge 10.x
FIX:
Enhancement request# OE00114815 has been implemented.
For Progress 9.1, upgrade to Progress 9.1E03 or higher.
For OpenEdge 10, upgrade to OpenEdge 10.1A01 or higher.
The NOLOCK option, allowing dirty reads, is only permissible in READ COMMITTED mode.
The syntax is:
SELECT <columns> FROM <table> WITH (NOLOCK)