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

EXT_CP_SUPPT Statement

EXT_CP_SUPPT Statement

The EXT_CP_SUPPT statement controls character conversion in
static code pages.
This statement controls whether PowerExchange converts certain characters from their EBCDIC to their corresponding ASCII values. The statement affects EBCDIC characters X'41', X'FF', and characters with a value of less than X'40'. X'40' represents the space character in an EBCDIC code page.
  • N
    . PowerExchange does not convert the affected characters. For example, PowerExchange leaves the X'25' character in an EBCDIC source code page as X'25' in a target ASCII code page. In the ASCII code page, its meaning changes from a LINE FEED to a PERCENT SIGN (%).
  • Y
    . PowerExchange converts any affected character to its Unicode meaning. For example, PowerExchange converts the X'25' character in the EBCDIC source code page IBM-037 to X'0A' in a target ISO-8859 code page. The Unicode name for this character is LINE FEED (LF).
Default is Y.
The EXT_CP_SUPPT statement affects a small number of single-byte code pages. The statement applies only when both code pages involved have internal numbers ranging from 1 through 40. These code pages have the following names:
  • HP-ROM8
  • IBM-037
  • IBM-273
  • IBM-277
  • IBM-278
  • IBM-280
  • IBM-284
  • IBM-285
  • IBM-297
  • IBM-424
  • IBM-500
  • IBM-870
  • IBM-1047
  • ISO-8859
  • MS-1250
  • PC-856
  • USRCP00
In PowerExchange releases earlier than 9.6.0, the EXT_CP_SUPPT default is N. In PowerExchange 9.6.0 and later, the default is Y. If you need to retain the previous default method of mapping for particular EBCDIC values (for example, if you need to map EBCDIC X'FF' to ASCII X'FF'), Informatica recommends that you create a customized ICU code page.


We’d like to hear from you!