Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Transaction Behavior : Enhancing performance with locking hints
 

Enhancing performance with locking hints

A range of table-level locking hints can be specified using the SELECT, INSERT, UPDATE, and DELETE statements to direct the OpenEdge SQL Engine to the type of locks to be used. Table-level locking hints can be used when a finer control of the types of locks acquired on an object is required. These locking hints override the current transaction isolation level for the session.
* The READPAST locking hint