Chapter 5 Database Options
159
Deleting option settings
If option-value is omitted, the specified option setting will be deleted from
the database. If it was a personal option setting, the value reverts back to the
PUBLIC setting. If a TEMPORARY option is deleted, the option setting
reverts back to the permanent setting.
For example, the following statement resets the
ANSI_INTEGER_OVERFLOW option to its default value:
SET OPTION ANSI_INTEGER_OVERFLOW =
$ For more information, see "SET OPTION statement" on page 612.
Option classification
Adaptive Server Anywhere provides many options. It is convenient to divide
them into a few general classes. The classes of options are:
♦ "General database options" on page 161
♦ "Transact-SQL and SQL/92 compatibility options" on page 163
♦ "Replication options" on page 166
♦ "Interactive SQL options" on page 167
Initial option settings
Connections to Adaptive Server Anywhere can be made through the TDS
protocol (Open Client and jConnect JDBC connections) or through the
Adaptive Server Anywhere protocol (ODBC, Embedded SQL).
If you have users who use both TDS and the Adaptive Server Anywhere-
specific protocol, you can configure their initial settings using stored
procedures. As it is shipped, Adaptive Server Anywhere uses this method to
set Open Client connections and jConnect connections to reflect default
Adaptive Server Enterprise behavior.
The initial settings are controlled using the LOGIN_PROCEDURE option.
This option names a stored procedure to run when users connect. The default
setting is to use the
sp_login_environment
system procedure. If you wish to
change this behavior you can do so.
In turn,
sp_login_environment
checks to see if the connection is being made
over TDS. If it is, it calls the
sp_tsql_environment
procedure, which sets
several options to new "default" values for the current connection.
To Next Page
Loading...