D. Settings for Strict ANSI Compliance : Connection Flags : -numeric_overflow Connection Flag
 
Share this page                  
-numeric_overflow Connection Flag
The -numeric_overflow connection flag (see page Specify Error Handling for Arithmetic) specifies how the DBMS handles attempts to write numeric values that are outside the range of values supported by the data type of the receiving column (overflow and underflow).
The -numeric_overflow connection flag specifies behavior for integer, decimal, and floating point columns.
ANSI/ISO Entry SQL-92 and Ingres Default
Specify -numeric_overflow=fail (or omit this flag). If numeric overflow or underflow occurs, the statement that attempted to write the value fails and an error is issued. (This is the Ingres default behavior.)