Skip to Content

Using additional windows

Additional windows in File-AID for Db2 Related Table Edit provide further options and flexibility.

  • Table Not Found window: enables you to enter a valid creator or wildcard if a table is not found during the Related Table Edit process.
  • Creator Selection window: provides a list of creator identifications that have tables matching the selected dependent table.
  • Relationship Detail window: provides parent and dependent table information.
  • Relationship Information window: provides parent and dependent column information.

Specifying a New Creator

If the relationship you want to use references a table that is not found in the Db2 catalog, the Table Not Found window displays. It enables you to enter a valid creator for the selected table.

Table Not Found Window

image2021-3-10_14-41-4.png

If you enter an asterisk (*) in the CREATOR field, the Creator Selection window displays. Use the S line command to select the desired creator.

Creator Selection Window

image2021-3-10_14-41-42.png

Once you select a valid table, the Related Table Edit session begins (see the following figure).

Related Table Edit Display After Selecting New Creator

image2021-3-10_14-42-13.png

Relationship Detail Window

The Relationship Detail window (see the following figure) displays when you enter the I line command on the Relationship Listing window (Relationship Listing Window).

This window lists all relationships associated with the selected table, including relationships involving descendant tables. The type of relationship, RI or AR, is also listed. Enter the I line command to bring up the Relationship Information window. See Relationship Information Window.

Relationship Detail Window

image2021-3-10_14-42-56.png

Relationship Information Window

The Relationship Information window (AR Relationship Information and RI Relationship Information Window) displays when you enter the I line command in the Related Table List window (Related Table List Window) or the Relationship Detail window (Relationship Detail Window).

The Relationship Information window shows parent and dependent column information. The related columns appear under their respective parent or dependent table. Multiple columns may appear. Use standard scrolling commands to view additional columns.

The window is slightly different depending on whether the relationship is application relationship (AR Relationship Information) or an referential integrity (RI Relationship Information Window).

Application Relationship (AR) Information

If the relationship information is an application relationship, AR displays first in the Description field. The bottom of the screen displays the date it was created, the user identification of the person who created the relationship, the date the relationship was last modified, and the user identification of the person who last modified the relationship.

AR Relationship Information

image2021-3-10_14-43-49.png

Referential Integrity (RI) Information

If the relationship information is based on referential integrity, RI displays first in the Description field. The bottom of the screen displays the date the relationship was loaded, and the user identification of the person who loaded the relationship.

RI Relationship Information Window

image2021-3-10_14-44-22.png

Related topics

Application-Relationship-AR

Referential-Integrity-RI


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX File-AID for Db2 23.01