5.4.10 lobmid statement (specification of LOB middle file information)

When loading data to a table containing LOB columns, you can use the lomid statement to specify information about the LOB middle files.

During the creation of a LOB column structure base table, the system outputs information needed for data loading to LOB columns to LOB middle files.

Criteria
When loading data to a table with LOB columns, if you specify the -k d option, be sure to specify the lobmid statement. However, the lobmid statement, if specified, is ignored for a LOB input parameter to a constructor function that generates values to be stored in the columns of abstract data type.
Rules
  1. Specify the lobmid statement if you also specify the -k f, -k c, or -k v option.
  2. The contents of a LOB middle file depend on the specification of the -k option. If you are creating a LOB column structure base table separately from LOB data, you must specify the same -k option.
  3. When creating the LOB column structure base table and LOB columns at the same time, the source statement has precedence; therefore, there is no need to specify the server name, host name, or error information file name. If specified, they are ignored.
  4. If the target table contains no LOB column, do not specify the lobmid statement.
Organization of this subsection
(1) Format
(2) Explanation
(3) Notes about the LOB middle files

(1) Format

lobmid  [RDAREA-name][server-name|host-name]:
         LOB-middle-filename[,LOB-middle-filename]...
        [error=error-information-filename]

(2) Explanation

(a) RDAREA-name

[Figure]<identifier> ((1-30))

Specifies the name of the user LOB RDAREA.

If you omit this operand, the system loads the entire contents of the specified LOB middle files.

If you are specifying a replica RDAREA, specify the original RDAREA name for RDAREA-name and the target generation number in the -q option.

The system treats an RDAREA name in double quotation marks as case sensitive; otherwise, the system treats it as all uppercase letters. Enclose an RDAREA name in double quotation marks if it contains a space.

(b) [server-name|host-name]

Specifies the name of the server or host where the LOB middle files are located.

server-name [Figure]<identifier> ((1-8))
HiRDB/Single Server
Do not specify this information for a HiRDB/Single Server.
HiRDB/Parallel Server
Specify the name of the front-end server or back-end server where the specified LOB middle files are located.
If you specified an RDAREA name, you can omit this operand (be sure to specify either the RDAREA name or the server name).
If the server name is omitted, the system assumes the name of the server where the specified RDAREA is located.
host-name [Figure]<identifier> ((1-32))
HiRDB/Single Server
Specify the name of the host where the specified LOB middle files are located.
This must be the host name of the single server or the utility special unit.
You can omit this operand whether or not you specified an RDAREA name. If omitted, the system assumes the name of the host where the database load utility (pdload command) is executed.
HiRDB/Parallel Server
Do not specify this information for a HiRDB/Parallel Server.
(c) LOB-middle-filename

[Figure]<pathname>

Specifies the absolute pathname of a LOB middle file.

During the creation of a LOB column structure base table, the system outputs the information required for loading LOB column data to this LOB middle file. During the data loading to LOB columns, the system retrieves necessary information from this LOB middle file.

(d) error=error-information-filename

[Figure]<pathname>

Specifies the absolute pathname of the file to which error information is to be output.

This file must be located at the server machine or server where the LOB middle files are located.

If omitted, the database load utility creates a file with a unique name in the /tmp directory. For details about the error information file, see 5.6 Error information file.

(3) Notes about the LOB middle files

If you are creating a LOB column structure base table separately from LOB columns, note the following when creating the LOB columns:

  1. If you created a LOB column structure base table by executing pdload more than once using the same input data files, you can specify all the LOB middle files output by pdload in the lobmid statement when creating the LOB columns. In this case, make sure that each specified LOB middle file corresponds to the right line number in the input data file for the LOB column structure base table.
    If the order of the specified LOB middle files is wrong, an error results because the system cannot establish a correspondence with the LOB column input files.
  2. If you created a LOB column structure base table by executing pdload more than once using different input data files, you cannot specify more than one LOB middle file output by pdload in the lobmid statement at any one time when creating the LOB columns.
    If you specify more than one such LOB middle file at the same time, an error results because the system cannot establish a correspondence with the LOB column input files. Therefore, when creating the LOB columns, provide a LOB column input file corresponding to each input data file and execute pdload separately.