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 that are 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 that is specified for the Access Definition.
Indent tab
View
a list of table names in a format that shows the relationships that
are selected in the Access Definition. The rows on the Indent tab
are numbered for easy reference.
- Table
- The names of the tables that are 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 that are 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.