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 5. PowerExchange Code Page Names and Aliases

Report 5. PowerExchange Code Page Names and Aliases

This report displays the PowerExchange number associated with a code page. The report is arranged in ascending order by alias name.
PowerExchange uses aliases in the following situations:
  • For DB2, PowerExchange adds the prefix “cp” in front of CCSID numbers to form aliases that are used to find the code pages. For example, a DB2 CCSID of 300 is changed to an alias of “cp300” before PowerExchange looks up the aliases to find PowerExchange CPN 252.
  • You can specify the PowerExchange CODEPAGE configuration parameter with aliases, such as:
When using aliases in these situations, the “cp” format of alias or the PowerCenter name is recommended.
EBCDIC code pages are less common than ASCII. EBCDIC code pages usually have the literal “EBCDIC” in the alias. The following example shows aliases of Denmark EBCDIC Denmark code pages:
191 EBCDIC-CP-DK 191 ebcdic-dk 225 ebcdic-dk-277+euro
Do not define the same alias on multiple code pages. Only the code page with the lower CPN number is used.
You can use the ICUALIAS parameter to change the alias definitions.
The following sample report shows PowerExchange code page names and aliases.
Report 5 : Power Exchange Code page Names and Aliases ===================================================== Number of Aliases = 1142 CPN Alias name Alias type --- ---------- ---------- 058 7-bit ASCII PM CP long description 171 Adobe Latin1 Encoding PM CP long description 171 AdobeLatin1Encoding 170 AdobeStandardEncoding ....
The following table describes the columns in the report:
PowerExchange code page number.
Alias name
ICU converter name.
Alias type
Type of code page alias.


We’d like to hear from you!