Collection Contents Index ansi_close_cursors_on_rollback option [compatibility] Next PDF

SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options  > Alphabetical list of options

ansi_integer_overflow option [compatibility]


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

Allowed values

On, Off

Default

On

Remarks

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.


Collection Contents Index ansi_close_cursors_on_rollback option [compatibility] Next PDF