Retrieve the value of a specific connection property or the values of all connection properties.
Connection properties apply to an individual connection. For descriptions of all connection properties, see SQL Anywhere 11.0.1 > SQL Anywhere Server - Database Administration > Configuring Your Database > Connection, database, and database server properties > Connection properties. The connection properties QueryBypassedCosted, QueryBypassedOptimized, QueryDescribedOptimizer, and StatementPostAnnotatesSimple apply to SQL Anywhere objects but not to IQ tables.
Use the connection_property system function to retrieve the value of a connection property. 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
A separate row appears for each connection, for each property.