Connection Properties

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 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.

Note: This reference points to SQL Anywhere documentation.

Examples

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.