Simple LO data in a separate file

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 High-Performance Loader (HPL) 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
begin figure description - This figure is described in the surrounding text. - end figure description

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 Figure 1 illustrate how the HPL inserts the Simple LO data into the column.

Copyright© 2018 HCL Technologies Limited