Using the Load Request Editor

Use the Load Request Editor to define or edit a Load Request to be used for Optim™ processing.

Load Request Editor. The elements of the Load Request Editor are described as follows.
Description
Optional text to identify the Load Request (up to 40 characters).
Tabs
The Load Request Editor tabs group parameters and options that you may need to define and maintain Load Requests. Each tab in the editor serves a unique purpose.
General
Specifications for running DBMS loaders. Each time you open the editor, the General tab is shown first.
<DB Alias>
The Load Request Editor includes a tab for each DB Alias required for tables in the Table Map.
Age Function
Default parameters for optional aging of data in columns for which an Age function is indicated in a Column Map.
Global Aging
Default parameters for optional aging of data in columns that have a native date data type.
Currency
Default Currency Table and currency conversion parameters for columns with a native currency data type.
Report Options
Parameters for displaying errors and aging specifications on the process report.
Notify
Options for automatic email notification of the success or failure of the process.

Menu Commands

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

Tools Menu
Convert to Local
Embed the Load Request in the Restore Request. (Available only when editing a named Load Request as an adjunct to editing a Restore Request.)
Edit Table Map
Open the Table Map Editor, and create, edit, or browse a Table Map to be used with the active Load Request. For complete details on Table Maps, refer to the Common Elements Manual.
Respecify Options
Open the Load Request Editor Options dialog to modify the names of the Source File, Control File, or Table Map options.
Edit Exception Table Map
Open the Exception Table Mapping dialog to explicitly designate Exception or 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 a command to hide or display the corresponding tabs.