sa_conn_list system procedure

Returns a result set containing connection IDs.

Syntax

sa_conn_list( 
[ connidparm ] 
[, dbidparm ] 
)

Arguments

connidparm Use this optional INTEGER parameter to specify the ID number of a connection.
dbidparm Use this optional INTEGER parameter to specify the ID number of a database.

Result set

Column name	Data type	Description
Number	INTEGER	The ID number of the connection.

Remarks

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.

Permissions

None

Side effects

None