ACCESS / AQL
locking modifier
.mdThe locking modifier locks an item for AQL report processing. The purpose of this modifier is to prevent transient GFEs when using the AQL list or select commands on large items that are being simultaneously updated by another user/process.
Syntax
{command} {modifiers} locking
Note: Depending upon the item size, amount of memory and
the number of users, the locking modifier can have
an impact on performance. As such, this modifier should only be used
when the file contains items large enough to be stored out of group
and the file is often updated while being read.
Examples
select myfile if A5000 = "big file" locking