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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

divide_by_zero_error option

Controls the reporting of division by zero.

Allowed values

On, Off

Default

On

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

This option indicates whether division by zero is reported as an error. If the option is set On, then division by zero results in an error with SQLSTATE '22012'.

If the option is set Off, division by zero is not an error. Instead, a NULL is returned.