5.4.8 lobdata statement (specification of LOB input file information)

When loading data to a table containing LOB columns or entering LOB data as an input parameter for a constructor function, you can use the lobdata statement to specify the LOB information.

Criteria
Specify the lobdata statement when loading data to a table with LOB columns (except when loading data only to the LOB column structure base table).
You can also specify the lobdata statement when loading data to a table with abstract data type columns using LOB data as an input parameter to a constructor function.
Rules
  1. You can specify the lobdata statement if you also specify the -k f, -k c, or -k v option.
  2. You can load data to both LOB column structure base tables and LOB columns at the same time or to the LOB column structure base tables first and then to the LOB columns.
    If you are loading data only to the LOB column structure base table, do not specify the lobdata statement. The lobdata statement is required to store data in both LOB column structure base tables and LOB columns at the same time or to the LOB columns later.
  3. If you are providing a LOB input file for each LOB column and LOB parameter (LOB data as an input parameter to the constructor function), specify the file name in the data section corresponding to the LOB column in the input data file.
    If you specify the absolute path name of this file, the size of the input data file increases, resulting in complicated coding.
    If all LOB input files are stored in one directory, you should specify the directory name in the lobdata statement and the file names in the input data file, in which case the utility combines the specified directory name and file name to obtain the absolute path name. Note that this directory name specification is valid only when the names of LOB input files are specified in the input data file; otherwise, the utility ignores the directory name, if specified.
  4. If the target table contains no LOB column or the input parameter of the constructor function for creating values to be stored in the abstract data type is not LOB data, do not specify the lobdata statement.
Organization of this subsection
(1) Format
(2) Explanation
(3) Notes

(1) Format

lobdata [{LOB-input-filename[,LOB-input-filename]
|LOB-input-file-directory-name}]
[EasyMT-information]

(2) Explanation

(a) {LOB-input-filename[,LOB-input-filename]| LOB-input-file-directory-name}

If LOB input files are EasyMT files, this operand specifies the names of the LOB input files; otherwise, this operand specifies the name of the directory that contains the LOB input files.

LOB-input-filename[,LOB-input-filename][Figure] <path name>
If the LOB input file is an EasyMT file, specify the absolute path name of that file. You can specify a maximum of two LOB input files.
When using MTguide, you can specify the symbolic device name or device group name controlled by MTguide.
LOB-input-file-directory-name[Figure] <path name>
If all LOB input files are placed in a specific directory, specify the absolute path name of the directory.
Specify this path name along with the LOB columns' file names in the input data file using the source statement or the LOB column input file name using the lobcolumn statement in such a manner that they result in the absolute path name of the LOB input file when combined.
Notes
  1. The absolute path name created can be no greater than 1,023 bytes.
  2. If you specify the absolute path name of the LOB input file in the input data file using the source statement or the LOB column input file using the lobcolumn statement, you can omit the directory name of the LOB input files.
(b) EasyMT-information

[{vol=volume-name|vol=(volume-name[,volume-name]...)}]

[,bufno=buffer-sectors-count]

Specify this operand if the LOB input files are EasyMT files.

By specifying a volume name, you can check to see if the actual volume has the specified name. If you do not want to check the volume name, omit this operand. If omitting a file name, do not specify a comma before the first specified item.

{vol=volume-name|vol=(volume-name[,volume-name]...)}
[Figure]<alphanumerics> ((1-6))
Specify the name of the file.
You can specify up to 255 volume names as long as they fit in one line.
bufno=buffer-sectors-count[Figure] <unsigned integer> ((1-256)) <<10>>
Specify the number of buffer sectors to be used by EasyMT.

(3) Notes

The following table describes the data loading method depending on whether or not there is a LOB column, an abstract data type column with the LOB attribute, or a lobdata statement. This example uses SGMLTEXT type as the abstract data type column with the LOB attribute.

Table definitionlobdata statement
SpecifiedNot specified
With LOB columnWith SGMLTEXT type columnsData is loaded to the LOB column structure base table, SGMLTEXT type columns, and LOB columns at the same time.Data is loaded to the LOB column structure base table and SGMLTEXT type columns at the same time. Data is then loaded to LOB columns.
Without SGMLTEXT type columnsData is loaded to the LOB column structure base table and LOB columns at the same time.Data is first loaded to the LOB column structure base table and then to LOB columns.
With no LOB columnWith SGMLTEXT type columnsData is loaded to the abstract data type column structure base table and SGMLTEXT type columns at the same time.
Without SGMLTEXT type columnsResults in an error.Data is loaded to the table without a LOB column or SGMLTEXT type column.