sa_conn_options system procedure

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

Syntax

sa_conn_options( [ connidparm ] )

Result set

Column name	Data type	Description
Number	INTEGER	Returns the ID number of the connection.
PropNum	INTEGER	Returns the connection property number.
OptionName	VARCHAR(255)	Returns the option name.
OptionDescription	VARCHAR(255)	Returns the option description.
Value	LONG VARCHAR	Returns 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.

Cloud note: Because of tenant database isolation rules, when this system procedure is run in the cloud it returns only information about the current tenant database.