General Tab

Before you can load data, you must specify how to run the DBMS load utilities.

General tab selected on Load Request Editor

Server Name

The workstation on which processing will take place, as specified on the Load Request Editor Options dialog. To process on a different machine, click Tools > Respecify Options.

Source File

The name of the Source File specified on the Load Request Editor Options dialog. To use a different Source File, click Tools > Respecify Options.

Control File

The name of the Control File specified on the Load Request Editor Options dialog. To use a different Control File, click Tools > Respecify Options.

Table Map Name

The Table Map specified on the Load Request Editor Options dialog. To use a different Table Map, click Tools > Respecify Options.

Run DBMS Loaders

When more than one DB Alias is required to access tables listed in the Table Map, indicate whether to run the DBMS loaders in parallel or in sequence.

In Parallel
Optim™ runs the different DBMS loaders at the same time.
In Sequence
Optim runs the different DBMS loaders one after another.
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 the DBMS loader if an error occurs. When more than one DB Alias is specified in the Table Map, and an error occurs in one DBMS loader:

Stop on first conversion error

Select this check box to stop Load Request processing when a conversion error occurs.

Clear this check box to continue processing when a conversion error occurs. Rows in error are recorded with an error message in the Results Report. Conversion processing continues to the end to record all possible errors.

If a conversion error occurs, the DBMS loader process is not initiated. See Report Options Tab 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 start the Create Utility each time before the DBMS loader performs the load, to allow you to create or drop objects in the destination database. Clear this check box to start the Create Utility only when necessary to create desired objects in the destination database. See the Common Elements Manual for further information about the Create Utility.

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.