Alphabetical list of options
170
ANSI_CLOSE_CURSORS_ON_ROLLBACK option
Controls whether cursors that were opened WITH HOLD are closed when a
ROLLBACK is performed.
ON, OFF
OFF
The draft SQL/3 standard requires all cursors be closed when a transaction is
rolled back. By default, on a rollback Adaptive Server Anywhere closes only
those cursors that were opened without a WITH HOLD clause. This option
allows you to force closure of all cursors.
The CLOSE_ON_ENDTRANS option overrides the
ANSI_CLOSE_CURSORS_ON_ROLLBACK option.
ANSI_INTEGER_OVERFLOW option
Controls what happens when an arithmetic expression causes an integer
overflow error.
ON, OFF
OFF
The ISO SQL/92 standard requires integer overflow should result in an
SQLSTATE = 22003 - overflow error. Adaptive Server Anywhere behavior
was previously different from this. The ANSI_INTEGER_OVERFLOW
option can be set to OFF to maintain compatibility with previous releases of
the software.
ANSI_PERMISSIONS option
Controls permissions checking for DELETE and UPDATE statements.
ON, OFF
Can be set for the PUBLIC group only. Takes effect immediately. DBA
authority is required to set this option.
ON
With ANSI_PERMISSIONS ON, the SQL/92 permissions requirements for
DELETE and UPDATE statements are checked. The default value is OFF in
Adaptive Server Enterprise. The following table outlines the differences.
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Scope
Default
Description
To Next Page
Loading...