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
  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

ICU Code Pages Based on EBCDIC Encoding

ICU Code Pages Based on EBCDIC Encoding

ICU code pages that are based on EBCDIC encoding meet either of the following conditions:
  • They support the characters a-z, A-Z, and 0-9 in the following standard EBCDIC ranges: x'81 to x'a9', x'c1' to x'e9, and x'f0 to x'f9.
  • They are double-byte characters that are used with standard EBCDIC code pages.
The following table lists these code pages:
Name
Typical Use
Character Length in Bytes
ibm-16804_X110-1999
Arabic
1
ibm-16804_X110-1999,swaplfnl
Arabic
1
ibm-420_X120-1999
Arabic
1
ibm-918_P100-1995
Arabic
1
ibm-1112_P100-1995
Baltic
1
ibm-500_P100-1995
Belgium, Switzerland
1
ibm-1156_P100-1999
Central & East Europe
1
ibm-13124_P100-1995
Chinese (simplified)
1
ibm-1388_P103-2001
Chinese (simplified)
1 to 2
ibm-4933_P100-2002
Chinese (simplified)
2
ibm-836_P100-1995
Chinese (simplified)
1
ibm-837_X100-1995
Chinese (simplified)
2
ibm-935_P110-1999
Chinese (simplified)
1 to 2
ibm-1159_P100-1999
Chinese (traditional)
1
ibm-1371_P100-1999
Chinese (traditional)
1 to 2
ibm-835_X100-1995
Chinese (traditional)
2
ibm-937_P110-1999
Chinese (traditional)
1 to 2
ibm-1025_P100-1995
Cyrillic
1
ibm-1123_P100-1995
Cyrillic
1
ibm-1154_P100-1999
Cyrillic
1
ibm-1158_P100-1999
Cyrillic
1
ibm-1142_P100-1997
Danish
1
ibm-1142_P100-1997,swaplfnl
Danish
1
ibm-277_P100-1995
Danish
1
ibm-1137_P100-1999
Devanagari
1
ibm-1122_P100-1999
Estonian
1
ibm-1157_P100-1999
Estonian
1
ibm-1097_P100-1995
Farsi
1
ibm-1147_P100-1997
French
1
ibm-1147_P100-1997,swaplfnl
French
1
ibm-297_P100-1995
French
1
ibm-1141_P100-1997
German
1
ibm-273_P100-1995
German
1
ibm-4971_P100-1999
Greek
1
ibm-875_P100-1995
Greek
1
ibm-12712_P100-1998
Hebrew
1
ibm-12712_P100-1998,swaplfnl
Hebrew
1
ibm-424_P100-1995
Hebrew
1
ibm-4899_P100-1998
Hebrew
1
ibm-803_P100-1999
Hebrew
1
ibm-1149_P100-1997
Icelandic
1
ibm-1149_P100-1997,swaplfnl
Icelandic
1
ibm-871_P100-1995
Icelandic
1
ibm-1144_P100-1997
Italian
1
ibm-1144_P100-1997,swaplfnl
Italian
1
ibm-280_P100-1995
Italian
1
ibm-1390_P110-2003
Japanese
1 to 2
ibm-1399_P110-2003
Japanese
1 to 2
ibm-16684_P110-2003
Japanese
2
ibm-290_P100-1995
Japanese
1
ibm-5123_P100-1999
Japanese
1
ibm-8482_P100-1999
Japanese
1
ibm-930_P120-1999
Japanese
1 to 2
ibm-939_P120-1999
Japanese
1 to 2
infa-FujitsuJEF
Japanese
1 to 2
infa-FujitsuJEF_kana
Japanese
1 to 2
infa-HitachiKEIS
Japanese
1 to 2
infa-HitachiKEIS_kana
Japanese
1 to 2
infa-jipse
Japanese
1 to 2
infa-jipse_kana
Japanese
1 to 2
infa-jp_ebcdic
Japanese
1 to 2
infa-jp_ebcdik
Japanese
1 to 2
infa-melcom
Japanese
1 to 2
infa-melcom_kana
Japanese
1 to 2
infa-unisys
Japanese
1 to 2
infa-unisys_kana
Japanese
1 to 2
ibm-13121_P100-1995
Korean
1
ibm-1364_P110-1997
Korean
1 to 2
ibm-833_P100-1995
Korean
1
ibm-834_P100-1995
Korean
2
ibm-933_P110-1995
Korean
1 to 2
ibm-1132_P100-1998
Lao
1
ibm-870_P100-1995
Polish
1
ibm-1153_P100-1999
Romanian
1
ibm-1153_P100-1999,swaplfnl
Romanian
1
ibm-1145_P100-1997
Spanish
1
ibm-1145_P100-1997,swaplfnl
Spanish
1
ibm-284_P100-1995
Spanish
1
ibm-1143_P100-1997
Swedish
1
ibm-1143_P100-1997,swaplfnl
Swedish
1
ibm-278_P100-1995
Swedish
1
ibm-1160_P100-1999
Thai
1
ibm-838_P100-1995
Thai
1
ibm-1026_P100-1995
Turkish
1
ibm-1155_P100-1999
Turkish
1
ibm-1146_P100-1997
UK English
1
ibm-1146_P100-1997,swaplfnl
UK English
1
ibm-285_P100-1995
UK English
1
ebcdic-xml-us
US and international
1
ibm-1047_P100-1995
US and international
1
ibm-1047_P100-1995,swaplfnl
US and international
1
ibm-1140_P100-1997
US and international
1
ibm-1140_P100-1997,swaplfnl
US and international
1
ibm-1148_P100-1997
US and international
1
ibm-1148_P100-1997,swaplfnl
US and international
1
ibm-37_P100-1995
US and international
1
ibm-37_P100-1995,swaplfnl
US and international
1
ibm-1130_P100-1997
Vietnamese
1
ibm-1164_P100-1999
Vietnamese
1
These code pages are based on IBM definitions and are used on i5/OS and z/OS.
IBM frequently describes code pages using CCSID numbers. PowerExchange uses aliases that begin with CP to match the CCSIDs. For example, "CP930" matches CCSID 930 and the ICU converter ibm-930_P120-1999.
IBM frequently indicates revisions by adding 4096 to the CCSID number, for example:
CCSID 300 and CCSID 16684 are related (16684 = 300 + 4096 * 4)
The following table lists CCSIDs that you can use in the same DB2 table on i5/OS or z/OS:
Typical Use
Single-Byte
SCCSID
Columns
Double-Byte
GCCSID
Columns
Mixed-Length
MCCSID
Columns
Japan - Extended English
1027
300
939
Japan - Extended Katakana
290
300
930
Japan - Katakana - Kanji
8482
16684
1390
Japan - Latin - Kanji
5123
16684
1399
Korean
833
834
933
Korean
13121
4390
1364
Simplified Chinese
836
837
935
Simplified Chinese
13124
4933
1388
Traditional Chinese
28709
835
937
Traditional Chinese (IBM Big-5)
1114
947
950