Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

PowerExchange Express CDC for Oracle Configuration File

PowerExchange Express CDC for Oracle Configuration File

PowerExchange 10.0 introduces a new parameter in the OPTIONS statement of the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
OPTIONS statement
The OPTIONS statement can now include the following optional parameter:
TRUNCINVALIDCHARS
Indicates whether to detect and remove invalid multibyte characters that appear at the end of a character field in an Oracle source table. The characters are invalid because they have been truncated. If you allow these invalid characters to be passed to a PowerCenter workflow that has an Oracle target, PowerCenter might corrupt subsequent columns in the target table when running in Unicode mode.
Options are:
  • Y
    . Remove invalid multibyte characters from the source data. The invalid characters are not passed to PowerCenter or applied to the target database.
  • N
    . Capture the invalid multibyte characters and pass them to PowerCenter. When the PowerCenter workflow tries to write the invalid characters to the target, Oracle issues an ORA-02290 error that reports a check constraint violation on the target database. Also, PowerCenter might corrupt data in the subsequent columns in the target table.
Default is N. If you receive the ORA-02290 error in this situation, set this parameter to Y.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.

0 COMMENTS

We’d like to hear from you!