The IN_DB_UTIL_SP_DB_CONNECTIONS_DISPLAY stored procedure will display a summary of the user connections to the database. Results will be displayed in both the Results grid and the Messages tab depending on the specified mode.
| Parameter | Description | |
|---|---|---|
| MODE | Type: | INPUT |
| Datatype: | TINYINT | |
| Default Value: | 2 | |
| Description | Specifies where to return the results for displaying. | |
| Options |
1 = Results are selected to the Results grid only. 2 = Results are selected to the Results grid and printed in the Messages tab. 3 = Results are printed in the Messages tab only. |
|
| V_RETURN_VAL | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description |
Specifies whether the execution of the procedure was successful or not. 0 = Success 1 = Error |
|
Examples
EXEC IN_DB_CONNECTIONS_DISPLAY; EXEC IN_DB_CONNECTIONS_DISPLAY 1; EXEC IN_DB_CONNECTIONS_DISPLAY 2; EXEC IN_DB_CONNECTIONS_DISPLAY 3;