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