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_info system procedure Next Page

sa_conn_list system procedure

Returns a result set containing connection IDs.


[ connidparm ]
[, dbidparm ]

Result set
Column nameData typeDescription
NumberINTEGERThe ID number of the connection.

If you do not specify any parameters, or if both parameters are NULL, the connection IDs for all connections to all databases running on the database server are returned. If connidparm is less than 0, only the connection ID for the current connection is returned. If connidparm is NULL and dbidparm is less than 0, the connection IDs for just the current database are returned. If connidparm is NULL, and dbidparm is not NULL and its value is greater than or equal to 0, the connection IDs for only that database are returned.



Side effects


See also