Quickly see the RI structure of a set of tables using RC/Update

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

Quickly see the RI structure of a set of tables in order to see the parent child relationships between tables using RC/Update for Db2 for z/OS (RCU).

Resolution

There is a report generated by the RB - RI Browse command or the RE - RI Edit .  The report produces an indented list of tables showing the level of the tables.
The tables are indented according to their parent/child relationships. Each child table is shown underneath its parent, indented by two spaces.

If a wildcard like TB% is used in the ITEM NAME then the indented report is displayed which would normally then be used to select a base table to be used for the Relational Browse session. 

It does quickly display the relationships 

RI relationships can create referential cycles; that is, a parent table can be a child of its child. In the following example, the table TBPROJECT is its own child table. This is shown both by the
appearance of TBPROJECT  indented under itself, and by the (3+) after the child TBPROJECT , indicating that the table first appeared in the RI relationship at sequential number 3.

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.

RUPLIST1 20.0   RC/Update Browse Table Selection -------   yyyy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ===> CSR
Option      => RB                    Object  => T           Mode  => O ONLINE
Item Name   => TB%                 > Creator => authid1   > Where => N
SSID: ssid  ------------------------------------------------------ authid1


Enter S to select the Base Browse Table.

S  XXXX  TABLE                               LVL   CREATOR  GROUP    RI
   ---------------------------------------------------------------------------
__    1. TBDEPT                               1    authid1           S
__    2.   TBDEPT (1+)                        2    authid1           S
__    3.   TBPROJECT                          2    authid1           S
__    4.     TBPROJECT (3+)                   3    authid1           S
__    5.     TBTASK                           3    authid1           S
__    6.       TBEMP_TASK_ROLE                4    authid1           S
__    7.   TBWORK_GROUP                       2    authid1           S
__    8.     TBEMP                            3    authid1           S
__    9.       TBDEPT (1+)                    4    authid1           S
__   10.       TBEMP_TASK_ROLE (6)            4    authid1           S
__   11.       TBPROJECT (3+)                 4    authid1           S
__   12. TBROLE                               1    authid1           S
__   13.   TBEMP_TASK_ROLE (6)                2    authid1           S
   ---------------------------------------------------------------------------

******************************* BOTTOM OF DATA ********************************