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