Data in a separate file

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
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 BYTE or TEXT file with the BYTE or TEXT column. The arrows in Figure 1 illustrate how the HPL inserts the BYTE or TEXT data into the column.

Copyright© 2018 HCL Technologies Limited