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

SQL Anywhere 12.0.1 » 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. Property names are case insensitive.

 Retrieve the value of a connection property
  • Use the CONNECTION_PROPERTY system function.

    For example, the following statement returns the number of pages that have been read from file by the current connection.

    SELECT CONNECTION_PROPERTY ( 'DiskRead' );
 Retrieve the values of all connection properties
  • Use the sa_conn_properties system procedure:

    CALL sa_conn_properties( );

    A separate row appears for each connection property.

 See also
 Connection properties