This section explains how SGML document data is stored in the table defined in 22.5 Defining a table and index in order to create the database called manual. The SGML document data is provided as sample files (file01 and file02).
Use the HiRDB database load utility (pdload) to store data in the table named manual.
Figure 22-4 provides an overview of pdload.
Figure 22-4 Overview of pdload
![[Figure]](figure/zu210040.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_S/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 column structure information file under the name /opt/HiRDB_S/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_S/plugin/_phsgml/sample/control_file; this file must contain the following information:
source /opt/HiRDB_S/plugin/_phsgml/sample/input_file
lobdata /opt/HiRDB_S/plugin/_phsgml/sample/
- Use HiRDB's pdload command to load the SGML document data from /opt/HiRDB_S/plugin/_phsgml/sample/file01 and /opt/HiRDB_S/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_S/plugin/_phsgml/sample/
column_file manual /opt/HiRDB_S/plugin/_phsgml/sample/control_file
- Press the Enter key.
The SGML document data has been stored in the table called manual.