Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties

 

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.

Prerequisites

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.

 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.

Results

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

Example

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

 See also