5.2.3 Loading data to a table with abstract data type columns provided by a plug-in

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

[Figure]

Organization of this subsection
(1) Command to be executed
(2) Control information file
(3) Input data file
(4) Column structure information file

(1) Command to be executed

The following explains the options specified with pdload:

-c column_file:
This is the name of the column structure information file.
MEDICINE_MANAGEMENT_TABLE
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 the LOB parameter files and specify their file names 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 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.

(3) 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.

(4) Column structure information file

This example specifies the column structure information file named column_file.

MEDICINE_ID
This is a column name for the first data item in the input file.
OPERATION_MANUAL
This is a column name for the second data item in the input file.
func=(SGMLTEXT,param=blob)
This specifies information about the constructor function used to generate the values that are stored in the abstract data type columns.
SGMLTEXT: Name of the constructor function
blob: Type of argument that is passed to the constructor function