Syntax
EXCLUSIVE class_nameParameters
Exclusive can be abbreviated as EXU.
class_name
The class to lock.
Description
The Exclusive logic command restricts access to a persistent class's database records. This class must be read by the method applying the lock.
Restrictions on record access are as follows:
For MCP-based systems using an Oracle database, records might be read by other users, but cannot be updated until either the end of the current transaction, or an EndUse logic statement (in a report).
For Windows-based applications using a SQL Server database, records are not accessible by other users until either the end of the current transaction, or an EndUse logic statement (in a report).
The Exclusive logic command is ignored if a logic statement specifying the Secure command option has been applied to the same class in the same method.
The function of the Exclusive logic command can be duplicated by locking a control-type record, but the Exclusive logic command enables faster access at execution time, as no locks have to be applied. However, this has the potential disadvantage of locking out all other users of the class until the lock is released.
Restrictions
Excessive use of the Exclusive logic command might result in long waits for other users, deadlocks, or an abort at runtime.