Viewing the violations table

The load job also creates two tables in the target database that contain information about records that passed the conversion but that the database server rejected. The tables are named tablename_vio and tablename_dia, where tablename is the name of the table being loaded.

About this task

View the violations table to browse through records that passed the filter and conversion but that the database server rejected. The writes these records into the violations table (tablename_vio). The data in the violations table has the same format as the database table.

The Informix® Guide to SQL: Syntax discusses in detail the information found in the violations table.

To view the violations table:

Procedure

  1. Choose Browsers > Violations from the HPL main window.
    The Violations Table Browser window appears, as the following figure shows.
    Figure 1. The Violations Table Browser window
    begin figure description - This figure is described in the surrounding text. - end figure description
  2. Type the name of the database and table that you want to review the violations or click the down arrows to make your choices from selection lists.
  3. Click Select.
    The following figure shows the first record of a violations table.
    Figure 2. A record in the Violations Table Browser window
    begin figure description - This figure is described in the surrounding text. - end figure description
  4. Click Next and Previous to move forward and backward through the violations table.
  5. Click Cancel to return to the HPL main window.