Retrieve the value of a specific server property or the values of all server properties.
Server properties apply across the server as a whole. For descriptions of all server properties, see SQL Anywhere Server - Database Administration > Configuring your database > Connection, database, and database server properties > Database server properties.
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.
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.
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