Overriding the system-default session parameters
The database server obtains values for the session parameters from the parameter-information descriptor. The database server initializes the parameter-information descriptor with the system-default session parameters in the following table. To override these system-default values, you can initialize your own parameter-information descriptor to set session parameters.
About this task
- mi_set_parameter_info()
- Sets session parameters for the current session
- mi_get_parameter_info()
- Obtains session parameters for the current session
To override the system-default session parameters:
Procedure
- Allocate a parameter-information descriptor.
- Fill the fields of the parameter-information descriptor
with the default session parameters you need.
If you do not set a particular field, the database server uses the system-default value in System-default session parameters for the associated session parameter.
- Pass a pointer to this parameter-information descriptor to the mi_set_parameter_info() function.
Results
You can examine existing session parameters with the mi_get_parameter_info() function. This function populates a user-defined parameter-information descriptor with the current session parameters.