General Tab

To load data, you must identify the source and provide other parameters to control processing. Also, 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 in the following text.

Server Name

To change server name, source file, control file, or table map, click Tools > Respecify Options:

The Optim™ server (if any) on which processing takes place.

Source File

The name of the source file for processing.

Control File

The name of the control file.

Table Map Name

The table map used for load processing.

Run DBMS Loaders

When processing across database management systems, indicate whether to run the DBMS loaders in parallel or in sequence. This group box is disabled when the table map for the load request includes tables from only one database.

Stop on Loader error

Stop a loader if an error occurs. When processing across data sources, and an error occurs when:

Stop on first conversion error

If a conversion error occurs, the DBMS loader is not initiated. Select this check box to stop all conversion processing when a conversion error occurs.

Clear the check box to continue processing when a conversion error occurs so that all possible errors are recorded in the results report. Be sure that the Report errors option on the Report Options tab is selected and that the Maximum number per table value is high enough to account for all possible errors.

Always Call Create

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 wanted objects in the destination database.

File Attachments

If the source file contains pseudo columns for file attachment data, indicate whether to:

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


Feedback