Using the Access Definition 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 might be hidden or unavailable.
Example of an Access Definition Editor, described as follows.

Description

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

Global Actions specified

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

Tabs

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

Tables
List tables, views, aliases, or synonyms to be included in a process that uses the Access Definition. Designate the Start Table and define Table Specifications. Each time that 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 you are editing or browsing data in a database, you can review only the relationships.
Variables
Define substitution variables to be used with selection criteria, SQL statements, or Extract or Restore Actions.
Point and Shoot
Provide parameters for a Point and Shoot list that is used to select specific rows from the Start Table. This tab is not available and settings on it do not apply when you are editing or browsing data in a database.
Group
Provide parameters to select rows that are based on values in a particular column in the Start Table. This tab is not available and settings on it do not apply when you are 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 that are listed in the Access Definition in a format that emphasizes the relationships between the tables.
Relationship Index Analysis
Analyze relationships between tables that are listed in the Access Definition to determine whether new DBMS indexes would enhance performance. If more DBMS indexes are needed, you can create them in Optim. For more information, see Relationship Index Analysis.
Show Steps
Describe the extract steps and traversal paths that are defined in the Access Definition in a narrative form. For more information, see Show Steps. This command is not available when you are editing or browsing data in a database.
Edit Point and Shoot
Open the Point and Shoot Editor to select individual rows from the Start Table and save the selected rows in a Point and Shoot list. This command is not available when you are editing or browsing data in a database. For more information, see Edit Point and Shoot List.

You can select the following command from the Options menu:

Advanced Options
Display the Uncommitted Read and Extract RowID columns 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. For more information, see Table Access and Key Lookup Limit.


Feedback