Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
High-Performance Loader User's GuideThe describes how to use the HCL Informix® to load and unload large quantities of data efficiently to or from Informix® databases.
The HPL browsing optionsThis section describes the browsing options that are available for the .
Browsing optionsUse the browsing options of the 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.
Reviewing records that the conversion rejectedWhen you run a load job, onpload creates a file that contains information about records of the data file that the conversion rejected.

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.

About this task

This file is named basename.rej where basename is the base name that you selected in step 7 of Creating a load job. When you use a generate option to create the components for a load job, basename is /tmp/jobname where jobname is the name that you selected for the unload job.

To review rejected records:

Procedure

On the HPL main window, select the project that contains your load job.
Choose Browser > Record to display the Record Browser window.
Type the name of the format to be applied to the rejected-records file in the Format text box. Or, click the format name in the list box.
Type the name of the rejected-records file in the Data File text box. Or, click the down arrow and select a data file from the selection list.
Click OK to display the second Record Browser window.
You can take the following actions:
- Type the record number that you want to view. Click Select.
- Click Next to display the next record.
- Click Previous to display the previous record.
Click Cancel to return to the HPL main window.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.