You can obtain a list of option settings, or the values of individual options, in a variety of ways.
For the connected user, the sp_iqcheckoptions stored procedure displays a list of the current value and the default value of database options that have been changed from the default. sp_iqcheckoptions considers all Sybase IQ and SQL Anywhere database options. Sybase IQ modifies some SQL Anywhere option defaults, and these modified values become the new default values. Unless the new Sybase IQ default value is changed again, sp_iqcheckoptions does not list the option.
sp_iqcheckoptions also lists server start-up options that have been changed from the default values.
When a DBA runs sp_iqcheckoptions, he or she sees all options set on a permanent basis for all groups and users and sees temporary options set for DBA. Users who are not DBAs see their own temporary options. All users see nondefault server start-up options.
The sp_iqcheckoptions stored procedure requires no parameters. In Interactive SQL, run the following command:
sp_iqcheckoptions
For more information, see sp_iqcheckoptions procedure in Chapter 7, “System Procedures”in Reference: Building Blocks, Tables, and Procedures.
The system table DBA.SYSOPTIONDEFAULTS contains all of the names and default values of the Sybase IQ and SQL Anywhere options. You can query this table to see all option default values.
Current option settings for your connection are available as a subset of connection properties. You can list all connection properties using the sa_conn_properties system procedure.
call sa_conn_properties
In Interactive SQL, the SET statement with no arguments lists the current setting of options.
SET
In Sybase Central, right-click a database and select Options from the submenu.
Use the following query on the SYSOPTIONS system view:
SELECT * FROM SYSOPTIONS
This shows all PUBLIC values, and those USER values that have been explicitly set.
You can obtain a single setting using the connection_property system function. For example, the following statement reports the value of the Ansinull option:
SELECT connection_property ('Ansinull')
