Kbase P162432: How to skip a record that is locked when using SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/03/2010 |
|
Status: Unverified
GOAL:
How to skip a record that is locked when using SQL-92
GOAL:
How to bypass a record that is already locked using SQL SELECT
GOAL:
How to avoid record contention using SELECT statement
FACT(s) (Environment):
Isolation level is set to READ COMMITTED
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Use WITH (READPAST NOWAIT) option.
e.g.: SELECT * FROM pub.Customer WHERE "Custnum" < 100 FOR UPDATE WITH (READPAST WAIT 1);