While preparing to edit a set of tables , how to see if there are SYSTEM or USER DEFINED referential integrity defined on the tables
using RC/Update for Db2 for z/OS (RCU).
The RB (Referential Browse) or the RE (Referential Edit) functions are able to display a set of tables with their referential integrity shown.
Using the RB or RE report displays the type of RI that are in place....while using a wildcard for the table an indented and referenced list is provided.
The RI column below as a sample has "S" and "U" in the column.
The "S" means that the table has SYSTEM RI which is defined in DB2.
The "U" means that the table has USER DEFINED RI which was created by RI/Manager. Also, the User Defined items have an "A" on the same line.
This means that the USER DEFINED relationship is ACTIVE. If the User Defined Relationship has been made INACTIVE by RI/Manager it will not be seen on this list.
The full set can be viewed and maintained by RI/Manager.
SYSTEM or DB2 defined RI are always active.
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 => T% > 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
---------------------------------------------------------------------------
__ 1. TABLE1 1 AUTHID1 U A
__ 2. TABLE1 (1+) 2 AUTHID1 U A
__ 3. TABLE2 2 AUTHID1 U A
__ 4. TABLE3 3 AUTHID1 U A
__ 5. TABLE3 (4) 3 AUTHID1 U A
---------------------------------------------------------------------------