Use the Load Request Editor to create,
modify, or delete Load Requests stored in the Optim™ Directory.
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.