CODESET values for import/export

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 character encoding 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
The following example shows how to specify UTF-8 encoding to export from the staff 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 table:
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
(NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8',0)
Related concepts
Importing into tables with identity columns
Executing import/export procedures from JDBC
File format for input and output
Treatment of NULLS
Related reference
Bulk-Import
Bulk-Export
Examples of bulk import and export