Datatype Conversion properties  Transfer properties

Chapter 3: Querying and Setting Operating Values

Data Conversion Error properties

The following table shows Data Conversion Error properties and associated global variables and set statements.

Table 3-6: Data Conversion Error properties

Configuration property

Global variable and

set statement

CharConvertError

select @@CharConvertError

set CharConvertError {reject | truncate}

DateTimeConvertError

select @@DateTimeConvertError

set DateTimeConvertError {reject | null | default}

NumConvertError

select @@NumConvertError

set NumConvertError {reject | null | default}





Copyright © 2005. Sybase Inc. All rights reserved. Transfer properties

View this book as PDF