Server properties apply across the server as a whole. This section describes how to retrieve the value of a specific server property or the values of all server properties. For descriptions of all server properties, see "Database server properties" in SQL Anywhere Server – Database Administration.
The Server Edition property returns the SQL Anywhere edition, not the Sybase IQ edition. To show Sybase IQ license information, use the sp_iqlmconfig system procedure. See “sp_iqlmconfig procedure”.
Retrieving the value of a server property
Use the property system function. The following statement returns the number of cache pages being used to hold the main heap:
select property ( 'MainHeapPages') from iq_dummy
Retrieving the values of all server properties
Use the sa_eng_properties system procedure:
call sa_eng_properties
