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

None

See also