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 IQ and ASA database options. IQ modifies some ASA option defaults, and these modified values become the new default values. Unless the new IQ default value is changed again, sp_iqcheckoptions does not list the option.
sp_iqcheckoptions also lists server startup options that have been changed from the default values.
When sp_iqcheckoptions is run, the DBA sees all options set on a permanent basis for all groups and users and sees temporary options set for DBA. Non-DBA users see their own temporary options. All users see non-default server startup 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”.
The system table DBA.SYSOPTIONDEFAULTS contains all of the names and default values of the IQ and ASA options. You can query this table, if you need 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
To order this list, you can call sa_conn_properties_by_name.
For more information, see the section “sa_conn_properties_by_name system procedure”.
In Interactive SQL, the SET statement with no arguments lists the current setting of options.
SET
In Sybase Central, right-click on a database, and select Options from the pop-up menu.
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')
