13. Understanding the Locking System : User-Controlled Locking--SET LOCKMODE : Ways to Specify a SET LOCKMODE Statement
 
Share this page                  
Ways to Specify a SET LOCKMODE Statement
There are several ways to specify the SET LOCKMODE statement:
Issue the SET LOCKMODE statement from a terminal monitor:
set lockmode session where readlock = nolock;
Include the SET LOCKMODE statement in an embedded language program. This affects only the session of the user issuing the statement.
Specify SET LOCKMODE with any of the following environment variables or logicals:
ING_SYSTEM_SET
Affects all users.
ING_SET
If set at the installation-wide level, affects all users.
If set at the local level, affects the user who set it.
ING_SET_dbname
Same as ING_SET but affects only the specified database.
dbname_SQL_INIT
Affects only the SQL terminal monitor for the specified database.
Can be set at the installation level or local level.
For example, to SET READLOCK=NOLOCK for your sessions using ING_SET, issue the following at the operating system prompt:
Windows:
set ING_SET="set lockmode session where readlock = nolock"
UNIX:
C shell:
setenv ING_SET "set lockmode session where readlock = nolock"
Bourne shell:
ING_SET = "set lockmode session where readlock = nolock"
export ING_SET
VMS:
define ing_set
"set lockmode session where readlock = nolock"
For further details on setting environment variables or logicals, see the System Administrator Guide.