23.6 Storing SGML documents in the table

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]

To store SGML documents in the table:

  1. 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

  2. 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)

  3. 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/

  4. 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

  5. Press the Enter key.
    The SGML document data has been stored in the table called manual.