Edit Table Selection Panel

To display the Edit Table Selection panel and access RI Editor, enter RE in the Option field of the Main Menu. The Edit Table Selection panel appears. Tables are listed in referential sets, when applicable, according to the selection criteria you entered for the Item Name, Creator, and Where fields. Dashed lines mark the beginning of a new referential set. Single table names surrounded by dashed lines indicate tables that are currently not in a referential integrity relationship with any other tables.
carcudb2
To display the Edit Table Selection panel and access RI Editor, enter
RE
in the Option field of the Main Menu. The Edit Table Selection panel appears. Tables are listed in referential sets, when applicable, according to the selection criteria you entered for the Item Name, Creator, and Where fields. Dashed lines mark the beginning of a new referential set. Single table names surrounded by dashed lines indicate tables that are currently not in a referential integrity relationship with any other tables.
The header fields are carried over from the Main Menu and the following selection column fields are listed for each table:
  • S (Selection
    )
    Enter
    S
    next to the table to be edited.
  • XXXX
    The sequential number of the table within the RI set. Each RI set of tables has its own set of numbers, beginning with 1 for the highest level parent table. In the previous example, the tables are numbered from 1 through 12, although there are only 6 tables in the set.
    Each solo table (one not associated with others by referential integrity) has an XXXX value of 1.
  • TABLE NAME
    The table name. The table names in an RI set are displayed in an indented hierarchical fashion, so the parent-child relationships can be visualized. Each child table is shown underneath its parent, indented by two spaces.
    Because of space limitations on the screen, only nine levels can be shown in the indented format with the full 18-character name field allowed. For RI sets with more than nine levels of tables, see the referential level number in the LVL column.
    RI relationships can create referential cycles; that is, a parent table can be a child of its child. In the previous example, the table DEPT is its own child table. This is shown both by the appearance of DEPT indented under itself, and by the (4+) after the child DEPT, indicating that the table first appeared in the RI relationship at sequential number 4.
  • CREATOR
    The creator (user ID) of the table.
  • GROUP
    The Group Name of a group of referentially related sets of tables, when applicable. The Group Name can reflect the application for which the table sets are grouped together. The Group Name is created by the RI Manager component of the Data Navigator product.
    Group names are valid only for user-defined RI sets.
  • RI
    The Referential Integrity type. S for system-defined, U for user-defined or NO RI.