CODESET values for import and export procedures

Import and export procedures accept arguments to specify codeset values. You can specify the codeset (character encoding) for import and export procedures to override the system default.

The following table contains a sample of the character encoding that is supported by JDK 1.x. To review the complete list of character encodings, refer to your Java documentation.

Table 1. Sample character encodings. This table contains sample character encodings supported by JDK1.x.
Character Encoding Explanation
8859_1 ISO Latin-1
8859_2 ISO Latin-2
8859_7 ISO Latin/Greek
Cp1257 Windows Baltic
Cp1258 Windows Vietnamese
Cp437 PC Original
EUCJIS Japanese EUC
GB2312 GB2312-80 Simplified Chinese
JIS JIS
KSC5601 KSC5601 Korean
MacCroatian Macintosh Croatian
MacCyrillic Macintosh Cyrillic
SJIS PC and Windows Japanese
UTF-8 Standard UTF-8

Examples of specifying the codeset in import and export procedures

The following example shows how to specify UTF-8 encoding to export to the staff.dat table:
CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
    (NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8')
The following example shows how to specify UTF-8 encoding to import from the staff.dat table:
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
    (NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8',0)
Related concepts
Methods for running the import and export procedures
Bulk import and export requirements and considerations
Bulk import and export of large objects
File format for input and output
Import and export procedures from JDBC
How the Import and export procedures process NULL values
Related tasks
Importing data using the built-in procedures
Exporting data using the built-in procedures
Related reference
Examples of bulk import and export