Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
CharConvertError [Table of Contents] DefaultDate

Access Service User's Guide DirectConnect for AS/400

[-] Chapter 2 Configuring the DirectConnect Access Service Library
[-] Access service Data Conversion Error properties
[-] DateTimeConvertError

DateTimeConvertError

Specifies the action an 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 that the access service rejects the row containing the error and issues a warning message.

null specifies that the access service inserts a NULL into the column and issues a warning message, unless the source column is defined as "not null."

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

Comments

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

CharConvertError [Table of Contents] DefaultDate