Using the Insert Request Editor

Use the Insert Request Editor to create, modify, or delete Insert Requests stored in the Optim™ Directory.

Insert Request Editor

Description

Enter text to describe the purpose of the Insert Request (up to 40 characters).

Server Name

If the optional Optim Server component is installed on your network, you can direct resource-intensive Insert Request processing (for example, when the source file contains a large number of tables or rows) to a machine hosting Optim 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 machine option is not enabled at your site, the Server Name box appears dimmed.

Tabs

The Insert Request Editor displays tabs that allow you to specify parameters and select options to define and maintain Insert Requests. Each tab in the editor serves a unique purpose.

General
Enter the 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
Specify default parameters for aging data in columns defined with 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
Enter parameters for displaying 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 commands, you can select the following commands from the other menus in the Insert Request Editor:

Tools
Menu
Convert to Local
When using a named Insert Request in a Restore Request, select this command to save the Insert Request as a local request within the Restore Request.
Edit Table Map
Opens the Table Map Editor, allowing you to create or edit a Table Map to be used with the active Insert Request. For details on creating and maintaining Table Maps, see the Common Elements Manual.
Edit Table Specifications
Opens the Insert Request Table Specifications dialog allowing you to select the tables to include in Mixed (selective) processing.
Edit Directory Map
Opens the Directory Map dialog, allowing you to map file attachments to destination directories.
Edit ACL
Open the Access Control List Editor to secure the Insert Request with an Access Control List. Available when Object Security is enabled.
Delete ACL
Delete the Access Control List securing the Insert Request. Available for secured Insert Requests only.
Options Menu
Show Aging/Show Currency
Select these commands to switch between hiding or displaying the corresponding tab.