You can also store Simple LO data in separate files.
During a load, Simple LO data files are read and inserted into
the database. During an unload job, the file is created and BYTE and
TEXT data is written to the file. When the fixed-format input contains
the path name of a data file, the uses
that path name to insert data into a column of the database table,
as the following figure shows. When you prepare the format, select Blob
File for the data type. Figure 1. Simple LO data in a file
When you create a map to link the fields of the input record to
the columns of a database table, link the name of the Simple LO file
with the Simple LO column. The arrows in Simple LO data in a file illustrate how the
HPL inserts the Simple LO data into the column.
