sa_conn_options system procedure

Returns property information for connection properties that correspond to database options.

Syntax

sa_conn_options( [ connidparm ] )

Arguments

connidparm Use this optional INTEGER parameter to specify the ID number of a connection.

Result set

Column name	Data type	Description
Number	INTEGER	The ID number of the connection.
PropNum	INTEGER	The connection property number.
OptionName	VARCHAR(255)	The option name.
OptionDescription	VARCHAR(255)	The option description.
Value	LONG VARCHAR	The option value.

Remarks

Returns the connection ID as Number, and the PropNum, OptionName, OptionDescription, and Value for each available connection property that corresponds to a database option.

If you do not specify connidparm, then option values for all connections to the current database are returned. If connidparm is less than zero, option values for the current connection are returned.

Permissions

None

Side effects