Reports connection property information.
sa_conn_properties( [ connidparm ] )
connidparm Use this optional INTEGER parameter to specify the connection ID number.
Column name | Data type | Description |
---|---|---|
Number | INTEGER |
Returns the ID number of the connection. |
PropNum | INTEGER | Returns the connection property number. |
PropName | VARCHAR(255) | Returns the connection property name. |
PropDescription | VARCHAR(255) | Returns the connection property description. |
Value | LONG VARCHAR | Returns the connection property value. |
Returns the connection ID as Number, and the PropNum, PropName, PropDescription, and Value for each available connection property. Values are returned for all connection properties, database option settings related to connections, and statistics related to connections. Valid properties with NULL values are also returned.
If no connidparm is supplied, properties for all connections to the current database are returned. If connidparm is less than zero, property values for the current connection are returned.
Cloud note: Because of tenant database isolation rules, when this system procedure is run in the cloud it returns only information about the current tenant database.
None
None
The following example uses the sa_conn_properties system procedure to return a result set summarizing connection property information for all connections.
CALL sa_conn_properties( ); |
Number | PropNum | PropName | ... |
---|---|---|---|
79 | 37 | CacheHits | ... |
79 | 38 | CacheRead | ... |
... | ... | ... | ... |
This example uses the sa_conn_properties system procedure to return a list of all connections, in decreasing order by CPU time*:
SELECT Number AS connection_number, CONNECTION_PROPERTY ( 'Name', Number ) AS connection_name, CONNECTION_PROPERTY ( 'Userid', Number ) AS user_id, CAST ( Value AS NUMERIC ( 30, 2 ) ) AS approx_cpu_time FROM sa_conn_properties() WHERE PropName = 'ApproximateCPUTime' ORDER BY approx_cpu_time DESC; |
*Example courtesy of Breck Carter, RisingRoad Professional Services ( http://www.risingroad.com).
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |