Home | Previous Page | Next Page   Browsing > Browsing Options >

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.

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

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

To view the violations table
  1. Choose Browsers > Violations from the HPL main window.

    The Violations Table Browser window appears, as Figure 120 shows.

    Figure 120. The Violations Table Browser Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  2. Type the name of the database and table for which you want to review the violations or click the down arrows to make your choices from selection lists.
  3. Click Select.

    Figure 121 shows the first record of a violations table.

    Figure 121. A Record in the Violations Table Browser Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - 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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]