 
 
 ![ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility]](gif/backward.gif) 
 ![ANSI_PERMISSIONS option [compatibility]](gif/forward.gif) 
 ASA Database Administration Guide
  Database Options
    Alphabetical list of options
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 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.
 
 
 ![ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility]](gif/backward.gif) 
 ![ANSI_PERMISSIONS option [compatibility]](gif/forward.gif)