Using the Editor

Use the Access Definition Editor to create or edit an Access Definition.

Note: When you open the Access Definition Editor from a process request editor, parameters unique to other types of processes may be hidden or unavailable.
access definition editor tables tab

Description

Text that identifies the purpose of the Access Definition (up to 40 characters).

Global Archive Actions specified

A read-only check box that indicates whether Global Archive Actions are defined within the Access Definition. When table-specific Archive Actions are defined, an icon is displayed in the Table Specifications column.

Tabs

The Access Definition Editor allows you to enter specifications and select options used to define an Access Definition. It includes the following tabs:

Tables
List tables, views, aliases or synonyms to be included in a process using the Access Definition. Designate the Start Table and define Table Specifications. Each time you open the editor, the Tables tab displays first.
Relationships
Designate the relationships to be traversed to select the set of related data from the referenced tables. (If editing or browsing data in a database, you can only review the relationships.)
Variables
Define substitution variables to be used with selection criteria, SQL statements, or Extract or Restore Archive Actions.
Point and Shoot
Provide parameters for a Point and Shoot list used to select specific rows from the Start Table. This tab is not available and settings on it do not apply when editing or browsing data in a database.
Group
Provide parameters to select rows based on values in a particular column in the Start Table. This tab is not available and settings on it do not apply when archiving, editing, or browsing data in a database.

Menu Commands

In addition to the standard File, Edit, and Tools menu commands, you can select these commands from the Tools menu:

Convert to Local
Convert parameters in a named Access Definition, referenced in a process request, to Local. You can edit the Local Access Definition for the process without affecting the named Access Definition.
Indent
Display the tables listed in the Access Definition in a format that emphasizes the relationships between the tables.
Relationship Index Analysis
Analyze relationships between tables listed in the Access Definition to determine if new DBMS indexes would enhance performance. If additional DBMS indexes are needed, you can create them in Optim. See Relationship Index Analysis.
Show Steps
Describe the extract steps and traversal paths defined in the Access Definition in a narrative form. See Show Steps. This command is not available when editing or browsing data in a database.
Edit Point and Shoot
Open the Point and Shoot Editor to allow you to select individual rows from the Start Table and save the selected rows in a Point and Shoot list. (See Edit Point and Shoot List.) This command is not available when editing or browsing data in a database.

You can select the following command from the Options menu:

Advanced Options
Display the Uncommitted Read column on the Tables tab and the Table Access and Key Lookup Limit grid columns on the Relationships tab. If you do not select this command, these columns are displayed only if a column contains a value other than the default. (SeeTable Access and Key Lookup Limit.)