sa_conn_list System Procedure

Syntax

sa_conn_list ([ connidparm ] [ ,dbidparm])

Parameters

connidparm – use this optional INTEGER parameter to specify the connection ID number.
dbidparm – use this optional INTEGER parameter to specify the database ID number.

Privileges

You must have EXECUTE privilege on the system procedure. You must also have one of the following system privileges:

SERVER OPERATOR
MONITOR
DROP CONNECTION

Remarks

Column Name	Data Type	Description
Number	INTEGER	The connection ID number.

If connidparm is greater than zero, then information for the supplied connection is returned. If connidparm is less than zero, then information for the current connection is returned. If connidparm and dbidparm are not supplied or are NULL, then connection IDs for all connections to all databases running on the database server are returned.

If connidparm is NULL and dbidparm is greater than or equal to zero, then connection IDs for only that database are returned. If connidparm is NULL and dbidparm is less than zero, then connection IDs for just the current database are returned.

Example

The following example uses the sa_conn_list system procedure to display a list of connection IDs.

CALL sa_conn_list( );

Number
1,949
1,948
...