Connection properties are available for each connection to a SQL Anywhere database. You can use the CONNECTION_PROPERTY system function to retrieve the value for an individual property, or you can use the sa_conn_properties system procedure to retrieve the values of all connection properties.
No privileges are required to view the connection properties for your connection. To view the connection properties for other connections, you must have either the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.
Context and remarks
Property names are case insensitive.
Use one of the following methods to access connection property values:
|Retrieve the value of a connection property||Use the CONNECTION_PROPERTY system function.|
|Retrieve the values of all connection properties||Use the sa_conn_properties system procedure.|
The following statement returns the number of pages that have been read from file by the current connection.
SELECT CONNECTION_PROPERTY ( 'DiskRead' );
Use the sa_conn_properties system procedure to retrieve the values of all connection properties:
CALL sa_conn_properties( );
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|