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 of the connection properties, see the section “Database properties” in the chapter “Database Performance and Connection Properties” in the Adaptive Server Anywhere Database Administration Guide.

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' )

1. Use the sa_conn_properties system procedure.

call sa_conn_properties

A separate row is displayed for each connection, for each property.