Contents Index ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility] ANSI_PERMISSIONS option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ANSI_INTEGER_OVERFLOW option [compatibility]


Function 

Controls what happens when an arithmetic expression causes an integer overflow error.

Allowed values 

ON, OFF

Default 

OFF

Description 

The ISO SQL/92 standard requires integer overflow should result in a 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.


Contents Index ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility] ANSI_PERMISSIONS option [compatibility]