Using the Insert Request Editor

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

Insert Request Editor. The elements of the Insert Request Editor are described as follows.
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.