Table of Contents


  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. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

Creating the UCM File

Creating the UCM File

The UCM file maps the relationship between Unicode characters and hexadecimal values in the code page.
Edit the UCM file in a text editor. The file must contain only 7-bit ASCII characters on Linux, UNIX, and Windows systems, or the equivalent characters on EBCDIC systems.
The following table shows valid values for the precision indicator:
Precision Indicator
Normal, round-trip mapping.
A character retains the same hexadecimal value after being copied from the code page to Unicode and then copied back to the code page again.
Fallback mapping. A character is copied from Unicode to the code page but not back to Unicode again. If a character was copied back to Unicode again, it would get a new Unicode value.
Invalid character.
The character will be replaced by the substitution character.
Reverse-fallback mapping.
A character is copied from the code page to Unicode but not back to the code page. If the character was copied back to the code page again, it would get a different hexadecimal value.
Most characters are defined as round-trip mappings and have Unicode or hexadecimal values.
Sometimes, however, it is necessary to use one-way mappings, which cause an overlap between characters. For example, if a character is in the source code page but not in the target code page, or if a character is invalid, you can define a reverse-fallback mapping for it. When PowerExchange reads the data, the reverse-fallback mapping causes the character to be changed to a Unicode character that is a near match.
For more information about UCM file format, see the following Web site:


We’d like to hear from you!