Actian X 12.0 | -numeric_overflow Connection Flag

SQL Reference Guide > SQL Reference Guide > J. Settings for Strict ANSI Compliance > Connection Flags > -numeric_overflow Connection Flag

Was this helpful?

-numeric_overflow Connection Flag

The -numeric_overflow connection flag 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 Actian X 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 Actian X default behavior.)

Last modified date: 08/14/2024