Kbase P96651: SQL-92: What is READPAST locking hint feature?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2010 |
|
Status: Verified
GOAL:
What is READPAST locking hint feature?
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: SQL
FIX:
READPAST locking hint is a feature which causes a transaction to skip rows locked by other transactions that would ordinarily appear in the result set rather than blocking the transaction waiting for the other transactions to release their locks on these rows. For example:
SELECT * FROM PUB.Customer WHERE CustNum < 100 FOR UPDATE
WITH (READPAST WAIT 1)
Note that the READPAST lock hint applies only to transactions operating at READ COMMITTED Transaction Isolation Level mode