This section explains how SGML document data is stored in the table defined in 23.5 Defining a table and index in order to create the database called manual.
The HiRDB database load utility (pdload) is used to store data in the table named manual.
Figure 23-4 provides an overview of pdload.
Figure 23-4 Overview of pdload
![[Figure]](figure/zu220040.gif)
To store SGML documents in the table:
- Use an OS command, such as vi, to create a DAT-format input file under the name /opt/HiRDB_P/plugin/_phsgml/sample/input_file; this file must contain the following information:
1,file01
2,file02
- Use an OS command, such as vi, to create a file (column structure information file) under the name /opt/HiRDB_P/plugin/_phsgml/sample/column_file; this file must contain the following information:
num
doc,func=(SGMLTEXT,param=blob)
- Use an OS command, such as vi, to create a file (control information file) under the name /opt/HiRDB_P/plugin/_phsgml/sample/control_file; this file must contain the following information:
source f001:/opt/HiRDB_P/plugin/_phsgml/sample/input_file
lobdata /opt/HiRDB_P/plugin/_phsgml/sample/
- Use HiRDB's pdload command to load the SGML document data from /opt/HiRDB_P/plugin/_phsgml/sample/file01 and /opt/HiRDB_P/plugin/_phsgml/sample/file02 into the manual table. Enter the command shown as follows (in simple installation, the data is stored in the table in the no-log mode, which means that a log of database updates is not collected):
$PDDIR/bin/pdload -l n -c /opt/HiRDB_P/plugin/_phsgml/sample
/column_file manual /opt/HiRDB_P/plugin/_phsgml/sample/control_file
- Press the Enter key.
The SGML document data has been stored in the table called manual.