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)
DB2 Version 9.7 for Linux, UNIX, and Windows