CharConvertError  DefaultDate

Chapter 2: Creating and Configuring DB2 Access Services

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 issues 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”.)





Copyright © 2005. Sybase Inc. All rights reserved. DefaultDate

View this book as PDF