Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties


Accessing database server property values

Database properties apply across the database server as a whole. You can use the PROPERTY system function to retrieve the value for an individual property, or you can use the sa_eng_properties system procedure to retrieve the values of all database server properties. Property names are case insensitive.

 Retrieve the value of a database server property
  • Use the PROPERTY system function. For example, the following statement returns the number of cache pages used for global server data structures:

    SELECT PROPERTY ( 'MainHeapPages' );
 Retrieve the values of all database server properties
  • Use the sa_eng_properties system procedure:

    CALL sa_eng_properties;
 See also
 Database server properties