Kbase P96653: SQL-92: What is the syntax for READPAST locking hint?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/02/2007 |
|
Status: Verified
GOAL:
What is the syntax for READPAST locking hint?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
READPAST locking hint should be used together with the syntax "WITH" in a SELECT statement:
SELECT column_list
FROM table_list
[ WHERE search_condition ]
[ GROUP BY grouping_condition ]
[ HAVING search_condition ]
[ORDER BY ordering_condition ]
[WITH locking_hints ]
[FOR UPDATE update_condition ]
------
"locking_hints" can be defined as (READPAST [NOWAIT] [WAIT <timeout in seconds>])
For example:
SELECT * FROM Pub.Customer WHERE Balance > 1000 WITH (READPAST NOWAIT);