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-filename[,LOB-input-filename] |LOB-input-file-directory-name}] [EasyMT-information] |
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.
[{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.
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. |