ASA Database Administration Guide
  Database Options
    Introduction to database options

Finding option settings

You can obtain a list of option settings, or the values of individual options, in a variety of ways.

Getting a list of option 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.

  If you want to filter the result or order by anything other than name, you could also use a SELECT statement. For example:

  SELECT * 
  FROM sa_conn_properties()
  WHERE PropDescription like '%cache%'
  ORDER BY PropNum

  For more information, see sa_conn_properties_by_name system procedure, and sa_conn_properties 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 choose Options from the popup menu.

• Use the following query on the SYSOPTIONS system view:

  SELECT *
  FROM SYSOPTIONS

  This displays all PUBLIC values, and those USER values that have been explicitly set.

Getting individual option values 

You can obtain a single setting using the connection_property system function. For example, the following statement reports the value of the ANSI_INTEGER_OVERFLOW option:

SELECT CONNECTION_PROPERTY ('ANSI_INTEGER_OVERFLOW')

For more information, see CONNECTION_PROPERTY function [System].