Specify Error Handling for Arithmetic
To specify error handling for numeric overflow, underflow, and division by zero, set the ‑NUMERIC_OVERFLOW=option flag:
• On the CONNECT statement or
• On the command line for commands that accept SQL option flags. For details about SQL option flags, see the sql command.
where option is one of the following:
IGNORE
Issues no error
WARN
Issues a warning message
FAIL
(Default) Issues an error message and aborts the statements that caused the error. To obtain ANSI‑compliant behavior, specify this option (or omit the ‑NUMERIC_OVERFLOW flag).