Code Page Support
If any translation tables are defined in SYSIBM.SYSSTRINGS, they will appear on the Import window in the Codepage list box. The format in the list box is FROM n1 TO n2, where n1 is the number of the code page being translated from and n2 is the number of the code page being translated to.
When you select an item from the Codepage list box, Import loads the translation table for that conversion and uses it to convert character data during the import operation. You can specify which fields to convert by selecting Yes or No in the EBCDIC column of the Table Definition Grid. Normally, a conversion is performed for all applicable fields.
The format of the SYSIBM.SYSTRINGS table is as follows:
Column Name | Type | Length | Description |
---|---|---|---|
INCCSID | int | 2 | Code page number to translate From. |
OUTCCSID | int | 2 | Code page number to translate To. |
TRANSTYPE | CHAR | 2 | Not used by Import. |
ERRORBYTE | CHAR | 1 | Not used by Import. |
SUBBTYPE | CHAR | 1 | Not used by Import. |
TRANSPROC | CHAR | 8 | Not used by Import. |
IBMREQD | CHAR | 1 | Not used by Import. |
TRANSTAB | VARCHAR for bit data | 256 | Translation table to convert from INCCSID code page to OUTCCSID code page. |