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.
lobdata [LOB-input-file-directory-name] |
~<path name>
Specifies the name of the directory that contains the LOB input files.
If the group of LOB input files is contained in a single directory, this operand specifies the absolute path name of that directory.
Specify the path name in such a manner that the absolute path name of the LOB input files is obtained when the specified path name is combined with the LOB column file name in the input data file specified in the source statement, or with the name of the LOB column input file specified in the lobcolumn statement.
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 definition | lobdata statement | ||
---|---|---|---|
Specified | Not specified | ||
With LOB column | With SGMLTEXT type columns | Data 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 columns | Data 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 column | With SGMLTEXT type columns | Data is loaded to the abstract data type column structure base table and SGMLTEXT type columns at the same time. | |
Without SGMLTEXT type columns | Results in an error. | Data is loaded to the table without a LOB column or SGMLTEXT type column. |