Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

ansi_close_cursors_on_rollback option [compatibility] Next Page

ansi_integer_overflow option [compatibility]

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

Allowed values

On, Off




The ISO SQL/2003 standard requires integer overflow should result in a SQLSTATE = 22003 - overflow error. SQL 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.