SQL Anywhere provides a set of properties that are made available to client applications. These properties describe aspects of connection, database, and database server behavior. Property names are case insensitive.
Each type of property can be accessed by supplying its name as an argument to a system function.
To access connection properties
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' );
To access database properties
Use the DB_PROPERTY system function. For example, the following statement returns the page size of the current database:
SELECT DB_PROPERTY ( 'PageSize' );
To access database server properties
Use the PROPERTY system function: the following statement returns the number of cache pages used for global server data structures.
SELECT PROPERTY ( 'MainHeapPages' );
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|