Use the Insert Request Editor to define
or edit an Insert Request to be used for Optim™ processing.

- Description
- Optional text to identify the Insert Request (up to 40 characters).
- Server Name
If the Optim Server
is licensed and installed, you can direct resource-intensive Insert
Processing (for example, when the source file contains a large number
of tables or rows) to a machine hosting the Server.
Click
the down arrow to select a machine hosting Optim Server, or select Local to
process the request on the local workstation.
Note: If the Optim Server option is not enabled
at your site, Server Name is unavailable.
- Tabs
- The Insert Request Editor tabs group parameters
and options that you may need to define and maintain Insert Requests.
Each tab in the editor serves a unique purpose.
- General
- Specifications for the process, including the names
of the Source File, Control File, and Table Map. Each time you open
the editor, the General tab is shown first.
- 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 other menus in the Insert Request
Editor:
- Tools Menu
- Convert to Local
- Embed the Insert Request in the Restore Request.
(Available only when editing a named Insert 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
Insert Request. For complete details on Table Maps, refer to the Common
Elements Manual.
- Edit Table Specifications
- Open the Insert Request Table Specifications dialog
and select tables to include in Mixed (selective) processing. For
more information, refer to Insert Request Table Specification Dialog.
- Edit Directory Map
- Open the Directory Map dialog
and map file attachments to destination directories. For more information,
refer to Directory Map Dialog.
- Options Menu
- Show Aging Show Currency
- Select a command to hide or display the corresponding
tabs.