Use the Insert Request Editor to create,
modify, or delete Insert Requests stored in the Optim™ Directory.
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.