Using the 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.

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.