Loading data to a table with LOB columns

The figure below shows data loading to a table with LOB columns.

Figure 5-8 Loading data to a table with LOB columns

[Figure]

Organization of this subsection: (1) Command to be executed; (2) Control information file; (3) Input data file

(1) Command to be executed

The following explains the options specified with pdload:

PPICTURE: This is the identifier of the table subject to data loading.

control_file:: This is the name of the control information file.

For the omitted options, the system assumes the following values:

-d omitted: Addition mode

{-a|-b} omitted: Input data file in the DAT format

-i omitted: Batch index creation mode

-l omitted: Pre-update log acquisition mode

-k omitted: f (Provide as many LOB input files as there are LOB columns rows and specify the names of these LOB input files in the input data file.)

(2) Control information file

(a) source statement

The source statement specifies the input data file named /usr/inputfile.

(b) index statement

The index statement specifies the index information file named /usr/idxfile.

(c) lobdata statement

The lobdata statement specifies the LOB input file's directory named /usr/lobdata. This directory name is specified in such a manner that it results in the absolute path name when combined with the LOB input file name specified in the input data file.

(d) lobmid statement

The lobmid statement specifies the LOB middle file named /usr/lobmid_file.

(3) Input data file

This example specifies the input data file in the DAT format.

Additionally, the example provides separate LOB input files and specifies their names in the input data file.