param_extget

You display the name, data type, and current value of the database parameter specified. The system searches in the parameter file for the current database instance. If the parameter is not in the parameter file, the value from the default parameter file is output.

Prerequisites

You have the server authorization ParamRead.

Structure

param_extget <parameter_name>

Options
Option	Description
`<parameter_name>`	Name of the database parameter

Result

OK

<parameter_name> <type> <value>

Values for the Reply Fields
Value	Description
`<parameter_name>`	Name of the database parameter
`<type>`	Data type of the database parameter
`<value>`	Current value This is the value that is copied from the database parameter file at the start of the session. If the parameter is not in the parameter file, the default value from the default parameter file is displayed.

In the event of errors, see Reply Format.

More Information

Database Administration, Database Parameters