Related tables panel

You use the Related tables panel to display information about the tables related to the table being edited when you issued the REDIT command.

The panel displays a selection list showing all the Db2® objects that are directly related to the object being edited by an RI constraint. This includes tables that are parent tables in a relationship with the table being edited, and tables that are dependent tables in a relationship with the table being edited.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFE2)         Related tables for: DSN8910.EMP                 Top of 4
 4 rows fetched                                                     Format TABL
        RELATED  RELATED                                    COUNT
        TABLE    TABLE      RELATIONSHIP RELATIONSHIP  OF FOREIGN DELETE
 SEL    OWNER    NAME       NAME         TYPE         KEY COLUMNS RULE
        *        *          *            *                      * *       
 ----   #1--+--- #2--+----- #3--+----1-- #9--+----         ----#6 #10-+---
 ****  Top of data  ****
        DSN8910  DEPT       RDE          DEPENDENT              1 SET NULL
        DSN8910  EMPPROJACT REPAE        DEPENDENT              1 RESTRICT
        DSN8910  PROJ       RESPEMP      DEPENDENT              1 RESTRICT
        DSN8910  DEPT       RED          PARENT                 1 SET NULL
 ****  End of data  ****






 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F6=RChange
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
The entries shown on the Related tables panel depend on the cursor position when you issued the REDIT command:
  • If the cursor was not on the data for a column that is part of a foreign, parent or primary key, all related tables are shown.
  • If the cursor was on the data for a column that is part of a foreign, parent or primary key, only the related tables that include that column in a foreign, parent or primary key are shown.

The columns that are displayed include the SEL field, and columns of SYSIBM.SYSRELS.

SEL
Selection column. You can issue any of these line commands against the Db2® objects in the list:
A
Alter table.
ALS
Show aliases.
B
Browse table. (See Note 1)
C
Copy table.
CDI
Show column distribution statistics.
CH
Show child (dependent) tables.
CHR
Show child (dependent) relations.
CK
Show table check constraints.
COL
Show columns.
CON
Show table (unique and primary) constraints.
D
Show database.
E
Edit table. (See Note 1)
EE
Edit table - new session. (See Note 3)
FK
Show foreign keys.
I
Details about table or view.
KEY
Show relationship keys. (See Note 2)
P
Show privileges.
PA
Show parent tables.
PAR
Show parent relations.
PK
Show primary key.
PKG
Show packages.
PL
Show plans.
PR
Print table.
PST
Show partition statistics.
ROW
Show all columns for this row.
S
Show table spaces.
SYN
Show synonyms.
V
View table. (See Note 1)
VE
View table - new session. (See Note 3)
VW
Show views.
X
Show indexes.
XC
Show indexes and index columns.
Note:
  1. The E, B, and V commands edit, browse, or view the object by stacking a new FM/Db2 editor session on top of the existing FM/Db2 editor session. You cannot return to the original FM/Db2 editor session without first ending the new FM/Db2 editor session.
  2. For a parent relationship type, the KEY command shows the primary keys for the two tables in the relationship.

    For a dependent relationship type, the KEY command shows the foreign key columns for the two tables in the relationship.

  3. The EE and VE commands edit (or view) the object by starting a new ISPF logical session (split screen) and then starting a File Manager/Db2 editor session in the new logical session.
    • When the REDIT command was issued and the cursor was not located on the data for a column that is part of a parent, primary or foreign key, the new FM/Db2 editor session shows all rows of the table.
    • When the REDIT command was issued with the cursor located on the data for a column that is part of a parent, primary or foreign key, the new FM/Db2 editor session only shows those rows related to the row where the cursor was located.
    The FM/Db2 editor session of the related table may have no rows when:
    • For a dependent table, there are no rows in the table with a matching foreign key value.
    • For a parent table, the foreign key value contains one or more columns with the Db2® null value.

Parent panels

Child panels

Various. Depends on which line command entered.

Related tasks