Sets the return value for an overflow of
fractional seconds in TIMESTAMP.
- Equivalent CLI keyword
- TimestampTruncErrToWarning
- Equivalent IBM® data server
provider for .NET connection string keyword
- N/A
- IBM data server driver configuration
file (db2dsdriver.cfg) syntax
- <parameter name="TimestampTruncErrToWarning" value="0 | 1"/>
- Default setting:
- The overflow of fractional seconds in TIMESTAMP results in an
error (SQLSTATE 22007).
- Usage notes:
- The TimestampTruncErrToWarning keyword 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 10.5 for Linux, UNIX, and Windows