Accessing connection property values

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.

Prérequis

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.

Contexte et remarques

Property names are case insensitive.

Task

Use one of the following methods to access connection property values:

Option	Action
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.

Résultat

The connection property value is returned. A separate row appears for each connection property.

Exemple

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( );

Accessing connection property values

Task

See also