Data Conversion Error properties

Table 3-6 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}