Specify the Keyword For the Object To Be Locked
Be sure to specify the keyword for the object (database, table, view, or rowhash) that is to be locked.
For example, if a database and table are both named accntrec, then you could specify the following form:
LOCKING TABLE accntrec FOR ACCESS
SELECT *
FROM accntrec;
If the TABLE keyword had not been included, the lock would have been placed on the accntrec database.