Table of Contents

Search

  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. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

CODEPAGE Statement

CODEPAGE Statement

The CODEPAGE statement specifies the code pages that PowerExchange uses for operating system information, data, and literal values in SQL statements.
All
ADABASCODEPAGE, CONSOLE_CODEPAGE, DB2_BIN_CODEPAGE, DB2CODEPAGE, DTLMSG_CODEPAGE, LOG_CODEPAGE, and ORACLECODEPAGE
No
CODEPAGE=(
ctrl_cp
,
data_cp
,
SQL_cp
)
ctrl_cp
Required. Control code page identifier for operating system objects, such as program names and file names.
data_cp
Required. Code page identifier that overrides the code page of data. For example, when you extract data on Windows from z/OS sources, this value overrides the z/OS code page for that data.
SQL_cp
Required. Code page identifier for literal values used in SQL statements.
  • If you do not define the CODEPAGE statement, PowerExchange uses the default code page for the operating system for all parameters. The following table lists the default values by operating system:
    Operating System
    Default Code Page Values
    i5/OS
    IBM-037,IBM-037,IBM-037
    Linux, UNIX, and Windows
    ISO-8859,ISO-8859,ISO-8859
    z/OS
    IBM-037,IBM-037,IBM-037
  • This statement does not apply to the PowerExchange Navigator. The PowerExchange Navigator always uses the UTF-8 code page.
  • If you click
    Advanced Parms
    on the
    General Parameters
    page of the z/OS Installation Assistant, you can define the CODEPAGE_CONTROL, CODEPAGE_DATA, and CODEPAGE_SQL parameters. These values are used to populate the CODEPAGE statement in the DBMOVER file.
    • The CODEPAGE_CONTROL parameter corresponds to the
      ctrl_cp
      parameter in the CODEPAGE statement.
    • The CODEPAGE_DATA parameter corresponds to the
      data_cp
      parameter in the CODEPAGE statement.
    • The CODEPAGE_SQL parameter corresponds to the
      SQL_cp
      parameter in the CODEPAGE statement.