Browsing options

Use the browsing options of the High-Performance Loader (HPL) to preview records from the data file, review records after you perform a load or unload job, review various files associated with the HPL, and view the status of a load or unload job.

Preview data-file records
Before you actually run a load job, you can use the Record Browser window to check your definition of the format. The display shows errors such as incorrect field lengths or missing fields. You can edit the format to correct your format definitions.
Reviewing records that the conversion rejected
When you run a load job, onpload creates a file that contains information about records of the data file that the conversion rejected.
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.
View the status of a load job or unload job
When a load or unload job is complete, onpload writes a record of the load or unload job into a log file.

Parent topic: The HPL browsing options

Related concepts:

The Browse button

Related reference:

View error records