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.