Download IBM Optim: Optim Common Elements Manual

Relationship
Levels
Results
Children
ALL
Retrieve names of children, grandchildren, and so on. If the Related to Table
name is CUSTOMERS, ORDERS and DETAILS are retrieved. If the Related to
Table name is ORDERS, DETAILS is retrieved.
Parents
ALL
Retrieve names of parents, grandparents, and so on. If the Related to Table
name is CUSTOMERS, which has no parents, no names are retrieved. If the
Related to Table name is ORDERS, CUSTOMERS is retrieved. If the Related to
Table name is DETAILS, CUSTOMERS, ORDERS and ITEMS are retrieved.
Both
ALL
Retrieve names of all tables (children, parents, grandparents, grandchildren, and
so on). Use any table name in the example as the Related to Table name to
obtain the same set of table names. This default option is the one used most
often to retrieve table names for an entire data model.
Buttons
Select Select one or more table names and use Select to add the names to the list of tables on the Tables
tab of the Access Definition Editor.
Cancel
Use Cancel to return to the Access Definition Editor.
Refresh
Use Refresh to update the list of table names displayed to match the Pattern.
Select All Matching
Use Select All Matching to add all table names that match the criteria to the list of table names
on the Tables tab of the Access Definition Editor.
Display
Use Display to display the names of all related tables that match the pattern.
Relationships Tab
Use the Relationships tab to define the traversal path for selecting data from tables referenced in an
Access Definition. The traversal path determines the sequence in which a process visits each table. If
editing or browsing database data, the information on this tab cannot be edited.
The Start Table and any reference tables listed on the Tables tab are always included in a process.
However, in order to select related data from other tables listed in an Access Definition, you must define
the traversal path.
Chapter 4. Access Definitions
57