DateTimeConvertError

Specifies the action a DB2 access service takes when it encounters rows with date, time, or datetime data values that are out of range for the target datatype.

Syntax

DateTimeConvertError=[reject | null | default]

Default

reject

Values

reject specifies the DB2 access service to reject the row containing the error and issue a warning message.

null specifies the DB2 access service to insert a NULL into the column and issue a warning message (unless the source column is defined as “not null”).

default specifies that the DB2 access service inserts the default date and time values as configured in the DefaultDate and DefaultTime properties into the column (see “DefaultDate” and “DefaultTime”) and issues a warning message.

Comments

The SendWarningMessages property controls whether the DB2 access service returns warning messages to the client application. (See “SendWarningMessages”.)