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 codes in the input data are converted into the character codes specified for the column. Whether character codes are 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 code conversion is performed.
Table 5-1 Whether character code conversion is performed
Format of input data file | Whether the table subject to data loading contains a character set-defined column | |||
---|---|---|---|---|
Yes | No | |||
DAT format | Y | N | ||
Binary format | N#1 | |||
Fixed-size data format | Y | |||
File output by pdrorg | DAT format | Y | ||
Binary format | Unload file for pdload#3 | Y | ||
Unload file for pdrorg#3 | Y#2 | |||
Table transfer unload file#3 | Y |
pdload does not perform character code 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 codes for the character set-defined column. The table below shows the character codes used when input data files are created.
Table 5-2 Character codes used when input data files are created
Input data file format | Whether the table subject to data loading contains a character set-defined column | |
---|---|---|
Yes | No | |
DAT format | Default character set | Default character set |
Binary format | Character codes specified for the column | |
Fixed-size data format | Default character set |