Handling Overflow and Truncation Errors

The arithabort option determines how the SAP ASE server behaves when an arithmetic error occurs. The two arithabort options, arithabort arith_overflow and arithabort numeric_truncation, handle different types of arithmetic errors.

You can set each option independently, or set both options with a single set arithabort on or set arithabort off statement.

The arithignore option determines whether the SAP ASE server prints a warning message after an overflow error. By default, the arithignore option is turned off. This causes the SAP ASE server to display a warning message after any query that results in numeric overflow. To ignore overflow errors, use set arithignore on.