Value errors

Value errors occur during transfer processing when the value being inserted has one of the following characteristics:

• It cannot be converted to the target column’s datatype.

• It is out of range for the target column’s datatype.

The DB2 access service handles these errors using the following 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.

In addition, 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”.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF