Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_conn_list system procedure Next Page

sa_conn_options system procedure


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

Syntax

sa_conn_options( [ connidparm ] )

Arguments
Result set
Column nameData typeDescription
NumberINTEGERThe ID number of the connection.
PropNumINTEGERThe connection property number.
OptionNameVARCHAR(255)The option name.
OptionDescriptionVARCHAR(255)The option description.
ValueLONG VARCHARThe 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