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)