Retrieve the value of a specific server property or the values of all server properties.
Server properties apply across the server as a whole.
The Server Edition property returns the SQL Anywhere edition, not the SAP Sybase IQ edition. To show SQL Anywhere license information, use the sp_iqlmconfig system procedure.
Use the property system function to retrieve the value of a server property. The following statement returns the number of cache pages being used to hold the main heap:
select property ( 'MainHeapPages') from iq_dummy
Use the sa_eng_properties system procedure to retrieve the values of all server properties.
call sa_eng_properties