Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

CONVCHAR Statement

CONVCHAR Statement

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.
Default is ERROR.