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

See also