Use the Load Request Editor to define
or edit a Load Request to be used for Optim™ processing.
- 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.