TimestampTruncErrToWarning CLI/ODBC configuration keyword
Sets the return value for an overflow of fractional seconds in TIMESTAMP.
- db2cli.ini keyword syntax:
- TimestampTruncErrToWarning = 0 | 1
- Default setting:
- The overflow of fractional seconds in TIMESTAMP results in an error (SQLSTATE 22007).
- Usage notes:
- TimestampTruncErrToWarning controls whether the overflow of fractional
seconds in TIMESTAMP results in an error (SQLSTATE 22007) or a warning
(SQLSTATE 01S07). Set TimestampTruncErrToWarning as follows:
- 0 - to return the default error (SQLSTATE 22007)
- 1 - to return the warning (SQLSTATE 01S07)