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. The connection properties QueryBypassedCosted, QueryBypassedOptimized, QueryDescribedOptimizer, and StatementPostAnnotatesSimple apply to SQL Anywhere objects but not to IQ tables.
Retrieving the value of a connection property
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' )
Retrieving the values of all connection properties
Use the sa_conn_properties system procedure:
call sa_conn_properties
A separate row appears for each connection, for each property.
