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.

For a table that shows a sample of the character encodings supported by the Java Development Kit, see "derby.ui.codeset property" in the Derby Tools and Utilities Guide. To review the complete list of character encodings, refer to your Java documentation.

Examples: 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
Running 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