Select Indent from the Tools menu
to view the Indented Table Display dialog. The Indented Table Display
dialog has three tabs:
- On the Indent tab, a list
of tables referenced in the Access Definition is formatted to show
relationships.
- On the Reference tab, any
reference tables are listed.
- On the Unconnected tab, any
unconnected tables (tables that are not related to other tables on
the list) are listed.
Default Qualifier
Default
qualifier specified for the Access Definition.
Indent Tab
View
a list of table names in a format that shows the relationships selected
in the Access Definition. The rows on the Indent tab
are numbered for easy reference.
- Table
- The names of the tables listed in the Access Definition.
- The name of each table, except the Start Table,
is prefixed with a P (parent table) or a C (child table)
to show the relationship to the table under which it is listed.
- If a table is referenced several times (for example,
a child table with three parents), the suffix (n)
indicates the line number of the first occurrence.
- If a table is included in an RI cycle, the suffix
(CYCLE:n) indicates the line number of other tables
in the cycle.
- Relation
- Constraint name for the relationship with the table
under which the table is listed. The constraint name for the Start
Table is shown as Start Table.
- Type
- The type of relationship as defined in the DBMS
or the Optim™ Directory. This
grid cell is blank for the Start Table.
Reference Tables Tab
Tables designated as reference tables on the Access
Definition Editor Table List. The Reference
Tables tab is available only if you designated one or
more reference tables.
Unconnected Tab
Tables
on the Access Definition Editor table List that are not related to
any other table in the Access Definition. The Unconnected tab
is available only if one or more tables in the Access Definition cannot
be traversed during a process.