Previous Topic Next topic Print topic


EBCDIC_CODEPAGE (DSNTIAUL format)

Restriction: This topic applies to Windows environments only.

Specifies the source character set. The syntax is:

EBCDIC_CODEPAGE = n

where n is the code page number.

By default, Import assumes character data is stored in a DSNTIAUL source file using the American EBCDIC character set and converts it to the American ASCII character set before inserting it into an XDB Server table. See "ASCII Table" for a listing of ASCII character sets.

You can have the Import utility translate character data containing characters from any international EBCDIC character set to any international ASCII character set using the code page feature in Import. For the EBCDIC code page number, use the default EBCDIC character set for your country. EBCDIC to ASCII translation is performed using the translation table that corresponds to the specific ASCII and EBCDIC code pages. This translation table is in the TRANSTAB field of the SYSIBM.SYSSTRINGS table in the SYSTEM.

When the Import utility uses code page options, the values entered for EBCDIC_CODEPAGE and ASCII_CODEPAGE are compared with values for INCCSID and OUTCCSID, respectively, in the system table SYSIBM.SYSSTRINGS. The matching record in the table contains the translation table used to convert DSNTIAUL data in EBCDIC format to XDB Server data in ASCII format.

Previous Topic Next topic Print topic