The figure below shows data loading to a table with an abstract data type provided by a plug-in. This example uses the HiRDB Text Search Plug-in.
Figure 5-9 Loading data to a table with abstract data type columns provided by a plug-in
The following explains the options specified with pdload:
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 the LOB parameter files and specify their file names in the input data file.)
The source statement specifies the input data file named /usr/inputfile.
The index statement specifies the index information file named /usr/idxfile.
The lobdata statement specifies the LOB parameter 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 parameter file name specified in the input data file.
This example specifies the input data file in the DAT format.
Additionally, the example provides separate LOB parameter files and specifies their names in the input data file.
This example specifies the column structure information file named column_file.