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

Report 1. Power Exchange Control Table for Simple Code Pages

Report 1. Power Exchange Control Table for Simple Code Pages

This report displays a list of all simple code pages. Simple code pages are static single-byte code pages that provide a fast translation facility with the following limitations:
  • You can translate data between static code pages, but you cannot translate between static and ICU code pages.
  • You can use only a one-to-one mapping between characters, however you cannot use a one-to-many or many-to-one mapping between characters.
Static single-byte code pages are defined in the range of 1 to 40. User-defined static code pages are defined in the range of 31 to 40.
When translating between code pages, such as from CPN 1 “ISO-8859” to CPN 3 “IBM-037,” the operating system builds a translation table of 256 bytes that contains the appropriate target values. To translate a particular value such as x'31', the system finds the value x'31' in the translation table and uses the translated value that is stored for it, x'F1'.
On systems that do not support ICU processing, static code pages provide the facility to translate between code pages. Each static code page must have an equivalent ICU code page that is used if the other code page is ICU. For example, if you move data from CPN 3 “IBM-37” to CPN 41 “UTF-8,” the system converts from CPN 183 “ibm-37_P100-1995” to CPN 41 “UTF-8.”
The following report is a sample PowerExchange control table for simple code pages report:
Report 1 : Power Exchange control table for Simple code pages ============================================================= NUM_STATIC_CODEPAGES = 41 CPN Name PMlocale PowerCenter name Space CPN2 ICU Converter name --- ---- -------- ----------------- ----- ---- ------------------ 001 ISO-8859 Latin1 ISO 8859-1 Western European 20 057 ISO-8859-1 002 IBM-1047 IBM1047 IBM EBCDIC US English IBM1047 40 213 ibm-1047_P100-1995 003 IBM-037 IBM037 IBM EBCDIC US English IBM037 40 189 ibm-37_P100-1995 ....
The following table describes the columns in this report:
PowerExchange code page number.
Name of the code page. PowerExchange and PowerCenter exchange data using this code page name.
Name of the character set.
PowerCenter name
Code page description.
Hexadecimal value of the space character used to pad CHAR columns.
PowerExchange code page number of the equivalent ICU code page.
ICU Converter name
Converter name of the equivalent ICU code page.


We’d like to hear from you!