Data Movement Utilities Guide and Reference

Importing Large Objects (LOBs)

When importing into large object (LOB) columns, the data can come either from the same file as the rest of the column data, or from separate files. In the latter case, there is one file for each LOB instance.

The column in the main input data file contains either the import data (default), or the name of a file where the import data is stored.

Notes:

1. When LOB data is stored in the main input data file, no more than 32KB of data is allowed. Truncation warnings are ignored.

2. All of the LOB data must be stored in the main file, or each LOB is stored in separate files. The main file cannot have a mixture of LOB data and file names. LOB values are imported from separate files by using the lobsinfile modifier (see File Type Modifiers (Import)), and the LOBS FROM clause (see IMPORT Command).