Load Request Editor Options

When you create a load request, the Load Request Editor Options dialog opens with the Load Request Editor.

Load Request Editor Options dialog. The elements of the Load Request Editor Options dialog are described in the following text.

Server Name

Click the down arrow to select an Optim™ server, or select Local to process the request on the local workstation.

Source File

The name of a source archive or extract file used as the basis for the load request. This file provides the data model for a table map and, unless overridden, the data to be loaded. You can browse the contents of a source file by clicking Utilities > Browse or by right-clicking to select Browse from the menu.

Control File

The name of a control file, used to track the success or failure of processing each row in the source file. The .cf extension is added by default. If you do not provide a path with file names, the default data directory defined in personal options is used.

If you enter the name of an existing file, a dialog prompts to confirm that you want to overwrite the file. To disable the confirmation prompt, use personal options. You can browse the contents of a control file by clicking Utilities > Browse or by right‑clicking to select Browse from the menu.

Table Map Options

A table map matches tables in the source file to destination tables or excludes selected tables from processing. To be saved or processed, a load request must reference a valid table map. Click Tools > Edit Table Map from the menu to display the Table Map referenced for load processing.

Optionally, a table map might reference a column map for a pair of tables to:

Local
Embed a table map in the load request. Local table maps are saved as part of the load request and cannot be used with other process requests.
Named
Create or select a table map to use with the load request. You must provide a name for the table map. (If the database structure is changed since the table map was last used, a warning is displayed.)
Table Map Name
The table map used for processing.
Identifier
Identifier (1 - 8 characters) for the table map.
Name
Name (1 - 12 characters) of the table map.
Always View Table Map
Display the table map each time you save or run the load request. Clear this check box to display the table map only when needed (for example, when the data structure does not match that of the source file).


Feedback