IBM® Informix® 12.10

HPL load and unload errors

When you load records from a data file, some of the records might not meet the criteria that you established for the database table.

For example, the data file might contain:
  • Null values where the table specifies NOT NULL
  • Values in an incorrect format (for example, alphabetic characters in a numeric field)
  • Records that do not have the expected number of fields

The way that the HPL treats these errors depends on the mode (deluxe or express) and the type of job (load or unload).

The HPL separates errors into the following two classes:
  • Rejected records from the input file
    These records include:
    • Records that the filter rejected
    • Records that cannot be converted
  • Constraint violations
Parent topic: Manage the High-Performance Loader

Send feedback | Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.
timestamp Release date: March 2013