Setting the Mutability Property in an Active Session

Home | Previous Page | Next Page Utility Reference > onmode: Change Mode and Shared Memory >

Setting the Mutability Property in an Active Session

Setting Mutability Property in an Active Session:

|-- -q--+-----------+--var_name--session------------------------|
        +-MUTABLE---+
        '-IMMUTABLE-'

Element	Purpose	Key Considerations
var_name	Name of the environment variable whose mutability is being changed .	For variables that use more than one word, an underscore is used to make it one word.
session	The session id of the active session whose mutability is being changed.	The session id should correspond to the session id on the connection coserver.

To control resource utilization, a DBA can set the mutability property of certain environment variables. If an environment variable is set as IMMUTABLE, its value cannot be changed by a user.

When a session is initialized, the property is set using the sysdbopen() procedure. After initialization, you can use the onmode -q option to change the mutability of an environment variable during an active section.

For more information on setting the immutability property and using the sysdbopen() procedure, see the IBM Informix Guide to SQL: Syntax.