Sybase Adaptive Server Anywhere - Page 175

Chapter 5 Database Options
157
Finding option settings
You can obtain a list of option settings, or the values of individual options, in
a variety of ways.
♦ 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 "sa_conn_properties_by_name system
procedure" on page 966, "sa_conn_properties system procedure" on
page 965.
♦ 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 Set Options from
the popup 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
ANSI_INTEGER_OVERFLOW option:
SELECT CONNECTION_PROPERTY (’ANSI_INTEGER_OVERFLOW’)
$ For more information, see "CONNECTION_PROPERTY function "
on page 321.
Scope and duration of database options
You can set options at 3 levels of scope: public, user, and temporary.
Temporary options take precedence over user and public settings. User level
options take precedence over public settings. If you set a user level option for
the current user, the corresponding temporary option is set as well.
Getting a list of
option values
Getting individual
option values