You can also store BYTE and TEXT data in separate files.
During a load, BYTE and TEXT 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 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: BYTE or TEXT 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 BYTE or TEXT
file with the BYTE or TEXT column. The arrows in BYTE or TEXT data in a file illustrate how the
HPL inserts the BYTE or TEXT data into the column.
