Using the Load Request Editor

Use the Load Request Editor to create, modify, or delete Load Requests stored in the Optim™ Directory.

Load Request Editor

Description

Enter text to describe the purpose of the Load Request (up to 40 characters).

Tabs

The Load Request Editor displays tabs that allow you to specify necessary parameters and select options to define and maintain Load Requests.

General
Enter specifications for running the DBMS loaders. Each time you open the editor, the General tab is shown first.
DBMS (DB Alias)
The Load Request Editor shows a tab for each different database management system specified in the Table Map. Enter the specifications required for each DBMS.
Age Function
Specify default parameters for aging data in columns defined using an Age function in a Column Map.
Global Aging
Specify default parameters for aging data in columns that have a native date data type.
Currency
Select a default Currency Table and define currency conversion parameters for columns with a native currency data type.
Report Options
Select options for reporting errors and aging specifications on the process report.
Notify
Specify options for automatic email notification of the success or failure of the process.

Menu Commands

In addition to the standard File and Edit menu commands, you can select the following commands from the other menus in the Load Request Editor:

Tools Menu
Convert to Local
When using a named Local Request in a Restore Request, select this command to save the Load Request as a local request within the Restore Request.
Edit Table Map
Opens the Table Map Editor to allow you to create or edit a Table Map to be used only with the active Load Request. For details on creating and maintaining Table Maps, see the Common Elements Manual.
Respecify Options
Opens the Load Request Editor Options dialog to allow you to modify the names of the Source File and Control File, as well as Table Map options for the data you want to load.
Edit Exception Table Map
Opens the Exception Table Mapping dialog to allow you to explicitly state what tables should be created to contain rows the DBMS loader deems as exceptions (DB2®, Oracle, and Informix® only). Informix refers to these tables as Violation Tables.
Edit Partition Map
Open the Table Partition Mapping dialog to map a Destination Table to a Sybase Partition.
Estimate Resources
Create a Resource Estimation Report for this Load Request. For details see Resource Estimation.
Edit ACL
Open the Access Control List Editor to secure the Load Request with an Access Control List. Available when Object Security is enabled.
Delete ACL
Delete the Access Control List securing the Load Request. Available for secured Load Requests only.
Options Menu
Show Aging/Show Currency
Select these commands to switch between hiding or displaying the corresponding tab.