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. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

PowerExchange Static Code Pages

PowerExchange Static Code Pages

You can define up to 10 external code page tables using fixed names. Code pages are defined in sequential text files that PowerExchange reads at run time. The parameter is specified in the following format:
CODEPAGE=(,USRCP
NN
,)
The variable
NN
is a number from 00 to 09, such as USRCP07.
Add a PowerExchange static code pages in the following manner:
  • Add a control, data, or SQL code page in the DBMOVER configuration file.
  • Add field or data map-level code pages in data maps for nonrelational database sources from the PowerExchange Navigator.
The following table specifies the code page file name and location that you must use on each system:
System
Location and File name
i5/OS
USRCPnn member that is specified in the CODEPAGE parameter of the DBMOVER configuration file.
UNIX and Linux
USRCP
nn
.cp file in the directory where PowerExchange is installed.
Windows
USRCP
nn
.cp file in the directory where PowerExchange is installed.
z/OS
Data set that is allocated by the USRCP
nn
DD in the PowerExchange Listener or Client JCL.
You must specify 256 hexadecimal characters in 16 rows, each with 16 characters. Every character-pair of hexadecimal digits must be separated by a blank. The following example shows the code page table of an external code page file:
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 40 4F 7F 7B 5B 6C 50 7D 4D 5D 5C 4E 6B 60 4B 61 F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 7A 5E 4C 7E 6E 6F AC C1 C2 C3 C4 C5 C6 C7 C8 C9 D1 D2 D3 D4 D5 D6 D7 D8 D9 E2 E3 E4 E5 E6 E7 E8 E9 AE BE 9E EC 6D 8C 81 82 83 84 85 86 87 88 89 91 92 93 94 95 96 97 98 99 A2 A3 A4 A5 A6 A7 A8 A9 8E BB 9C CC 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 AA B0 B1 9F B2 6A B5 BD B4 9A 8A BA CA AF BC 90 8F EA FA E0 A0 B6 B3 9D DA 9B 8B B7 B8 B9 AB 64 65 62 66 63 67 5A 68 74 71 72 73 78 75 76 77 7C 69 ED EE EB EF 5F BF 80 FD FE FB FC AD 4A 59 44 45 42 46 43 47 D0 48 54 51 52 53 58 55 56 57 79 49 CD CE CB CF A1 E1 70 DD DE DB DC 8D C0 DF