sa_conn_options system procedure

sa_conn_options( [ connidparm ] )

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

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

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.

None

sa_conn_options system procedure

Syntax

Arguments

Result set

Remarks

Permissions

Side effects

See also