Connection properties

Connection properties apply to an individual connection. This section describes how to retrieve the value of a specific connection property or the values of all connection properties. For descriptions of all connection properties, see "Database properties" in SQL Anywhere Server – Database Administration.

Examples

StepsRetrieving the value of a connection property

  1. Use the connection_property system function. The following statement returns the number of pages that have been read from file by the current connection:

    select connection_property ( 'DiskRead' )

StepsRetrieving the values of all connection properties

  1. Use the sa_conn_properties system procedure:

    call sa_conn_properties

A separate row appears for each connection, for each property.