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

General Code Pages Available with PowerExchange

General Code Pages Available with PowerExchange

Use general code pages if the default code pages that PowerExchange supplies are not sufficient for your installation. PowerExchange uses general code pages to transmit data or metadata between systems.
Typically, general codes pages are used in the following circumstances:
  • Multibyte data is processed.
  • Data is outside of the ISO-8859 range on Linux, UNIX, or Windows, or outside of the IBM-037 range on i5/OS or z/OS.
Enter general code pages in the CODEPAGE statement of the DBMOVER configuration file. You can define the following types of general code pages in the CODEPAGE parameter:
  • Control code page
  • Data control code page
  • SQL code page
The following table describes the uses of each code page type that can be specified in the CODEPAGE parameter:
Code Page
Uses
Control code page
  • Names of databases, tables columns, or files.
  • User IDs or passwords.
  • Error messages.
Data control code page
  • Column and parameter data used on nonrelational database types where the code pages have not been specified, for example, at the field or data map level.
    Parameter data refers to data sent to the server and substituted where parameter markers (question marks) are present in Delete, Select, or Update SQL.
SQL code page
  • Code page of SQL used to access data.
    Typically, the SQL code page is the same as the control code page because table names can be processed by both.
    The SQL code page must be sufficiently precise to handle any literals.
If you specify the control code page and omit the data control and SQL code pages, PowerExchange uses the control code page for the data control and SQL code pages. For example, the following statements are equivalent:
CODEPAGE=(UTF8) CODEPAGE=(UTF8,UTF8,UTF8)
If you omit the CODEPAGE parameter on Linux, UNIX, or Windows, PowerExchange uses the following default values:
CODEPAGE=(ISO-8859,ISO-8859,ISO-8859)
If you omit the CODEPAGE parameter on i5/OS or z/OS, PowerExchange uses the following default values:
CODEPAGE=(IBM-037,IBM-037,IBM-037)
The PowerExchange Navigator overrides the code page specified in the DBMOVER configuration file, so that it can handle all characters. The PowerExchange Navigator uses UTF8 for the control, data, and SQL code pages.