Violations

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