Value errors occur during transfer processing when the value being inserted:
Cannot be converted to the target column’s datatype
Is out of range for the target column’s datatype
The DB2 access service handles these errors using these properties:
CharConvertError
NumConvertError
DatetimeConvertError
DefaultDate
DefaultTime
DefaultNum
If the SendWarningMessages property is set to yes, the DB2 access service sends a message to the client application when it encounters value errors.
Also, as mentioned in “Datatype conversion for transfer processing”, the preceding properties can be used to fill in default values when datatype conversion fails during both types of transfer.
For more information about properties, see Chapter 2, “Creating and Configuring DB2 Access Services.”
For information about values that cause errors for DB2 access service during bulk copy transfer, see “Bulk copy transfer errors”.