The CONVCHAR statement controls how PowerExchange handles conversion errors for CHAR and VARCHAR columns that it detects during bulk data movement read operations.
All
No
CONVCHAR=(
replacement_character
[,{
replacement_option
|
NULL
}]
[,
maximum_length
]
[,{
ERROR
|NOERROR}]
)
replacement_character
Required. The character that PowerExchange uses to replace the data of CHAR and VARCHAR columns that have conversion errors.
{
replacement_option
|
NULL
}
Optional. Controls what PowerExchange uses to replace the data of nullable columns that have conversion errors.
Enter one of the following options:
NULL
.
By default, PowerExchange replaces the data of nullable columns with nulls.
REPLACE.
PowerExchange replaces the content of nullable columns with the replacement character.
Default is NULL.
maximum_length
Optional. Maximum number of replacement characters that PowerExchange uses to replace the content of columns that have conversion errors.
{
ERROR
|NOERROR}
Optional. Controls whether PowerExchange treats columns that have conversion errors as fatal.
Enter one of the following options:
ERROR
.
By default, PowerExchange treats a conversion error for a column as fatal and terminates the data movement operation.
PowerExchange writes the PWX-000144 error message to the PowerExchange message log, which includes the column name and the row number where PowerExchange detected the conversion error.
NOERROR.
PowerExchange replaces the data in the column with the conversion error with the replace character and continues.
PowerExchange writes PWX-00142 message to the PowerExchange message log, which includes the number of conversion errors detected.