Alphabetical list of options
172
♦ Updates of columns that appear in an ORDER BY clause
♦ The FROM clauses is not allowed in UPDATE statements.
If the option is set to CURSORS, these same restrictions are in place, but
only for cursors. If a cursor is not opened with FOR UPDATE or FOR
READ ONLY, the database server chooses updatability based on the SQL/92
standard. If the ANSI_UPDATE_CONSTRAINTS option is CURSORS or
STRICT, cursors containing an ORDER BY clause default to FOR READ
ONLY; otherwise, they continue to default to FOR UPDATE.
"UPDATE statement" on page 637
ANSINULL option
Controls the interpretation of = and != with NULL values.
ON, OFF
ON
With ANSINULL ON, any comparisons with NULL using = or != are
unknown.
Also, aggregate functions on columns that contain NULL values cause the
warning ’null value eliminated in aggregate function’ (SQLSTATE=01003).
Setting ANSINULL to OFF allows comparisons with NULL to yield results
that are not unknown, for compatibility with Adaptive Server Enterprise, and
turns off the warning.
AUDITING option
Enables and disables auditing in the database.
ON, OFF
Can be set for the PUBLIC group only. Takes effect immediately. DBA
permissions are required to set this option.
OFF
This option switches auditing on and off.
Auditing is the recording of detailed information about many events in the
database in the transaction log. Auditing provides some security features, at
the cost of some performance.
♦ Turn on auditing
See also
Function
Allowed values
Default
Description
Function
Allowed values
Scope
Default
Description
Example
To Next Page
Loading...