General Tab, Load Request Editor

In order to Load data, you must identify the source and provide other parameters to control processing. Before you can load data, you must specify how to run the DBMS load utilities.

Load Request Editor with General as the active tab. The elements of the General tab are described as follows.

Server Name

The Server (if any) on which processing takes place. To process on a different machine, click Tools > Respecify Options.

Source File

The name of the Source File to process. To change the Source File, click Tools > Respecify Options.

Control File

The name of the Control File. To change the Control File, click Tools > Respecify Options

Table Map Name

The Table Map used for Load processing. To change the Table Map, click Tools > Respecify Options.

Run DBMS Loaders

When processing across multiple DBMSs, indicate whether to run the DBMS loaders in parallel or in sequence.

In Parallel
Archive runs loaders in parallel.
In Sequence
Archive runs loaders in sequence.
Note: This group box is disabled when the Table Map specified in the Load Request includes tables from only one database, that is, when only one <DB Alias> tab is displayed.

Stop on Loader error

Select this check box to stop a loader if an error occurs. When processing across DBMSs, and an error occurs in a loader:

Stop on first conversion error

If a conversion error occurs, the DBMS loader process is not initiated. Select this check box to stop all Load processing when a conversion error occurs or clear the check box to continue processing when a conversion error occurs. Rows in error and an error message are recorded in the Results Report. Conversion processing continues to the end to record all possible errors.

Refer to Report Options Tab, Load Request Editor to be sure that the Report errors option is selected and that the Maximum number per table value is set high enough to account for all possible errors.

Always Call Create

Select this check box to always start the Create Utility to create or drop objects in the destination database before loading. Clear this check box to start the Create Utility only when needed to create desired objects in the destination database. Refer to the Common Elements Manual for complete information.

File Attachments

If the source file contains file attachment pseudocolumns, indicate how the Load Process should proceed.

Fail
Fail the process.
Process as Columns
Process pseudocolumns as normal table columns. If matching columns do not exist in the table, the pseudocolumns are ignored.