Formats of supported datafile records

Data files can be structured in various ways. The High-Performance Loader (HPL) supports data-file records of the following formats:
  • Fixed-length
  • Delimited
  • Other formats

You can define new format components at any time. Also, you can test your format before you actually load or unload data.

The ipload utility includes options that let you modify the data before it is inserted into the database.

The ipload utility stores information about formats in the formatitem and format tables of the onpload database.
Important: To prepare the format component, you must know the format of the records in the data file. If you do not know the data-file format, you must get it from the person who provided the data file.

Copyright© 2019 HCL Technologies Limited