5.1.4 Data loading to a table for which a character set has been defined

When data is loaded to a table that contains a column for which a character set has been defined (character set-defined column), the character encoding of the input data is converted into the character encoding specified for the column. Whether character encoding is to be converted depends on the combination of the input data file format and the table that is the subject to data loading. The table below shows whether character encoding conversion is performed.

Table 5-1 Whether character encoding conversion is performed

Format of input data fileWhether the table subject to data loading contains a character set-defined column
YesNo
DAT formatYN
Binary formatN#1
Fixed-size data formatY
File output by pdrorgDAT formatY
Binary formatUnload file for pdload#3Y
Unload file for pdrorg#3Y#2
Table transfer unload file#3Y
Legend:
Y: Character encoding conversion is performed.
N: Character encoding conversion is not performed.
#1
Data stored in the database is not guaranteed because the utility stores data in the database without performing character encoding conversion.
#2
When you execute pdrorg, unload the data with -k unld specified and then use the unload data file that is output with the original character encoding of the predefined data type. If you perform reorganization with -k rorg specified and use the unload data file that is output in the encoding for the column for which a character set has been defined, the utility displays the KFPL15047-E message and cancels the processing.
#3
For details, see 5.5.6 pdrorg-output binary files.

pdload does not perform character encoding conversion when you perform data loading to a table that contains a character set-defined column in a binary-format input data file created by the user. Therefore, you must handle conversion of the data in the input data file into the character encoding of the character set-defined column. The table below shows the character encoding used when input data files are created.

Table 5-2 Character encoding used when input data files are created

Input data file formatWhether the table subject to data loading contains a character set-defined column
YesNo
DAT formatDefault character setDefault character set
Binary formatCharacter encoding specified for the column
Fixed-size data formatDefault character set
Organization of this subsection
(1) Notes

(1) Notes