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.
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.)