Table List - SYSIBM.SYSTABLES

The following figure is displayed when you select Option 3, Add AR, or Option 5, Load RI, and specify a pattern in the Creator or Table Name field on the DB2 Relationship Facilitator screen.

Table List - SYSIBM.SYSTABLES

This screen displays a list of Db2 objects defined in the Db2 catalog that match the pattern. If there are more objects that match the pattern you specified on the previous screen than will fit on the Table List - SYSIBM.SYSTABLES window, you can scroll the list using standard scrolling commands. Use this window to select the object for which File-AID for Db2 will add an application relationship or load the RI information to the relationship file. The resulting list of relationships associated with the selected object is displayed on the Relationship Detail screen.

CMD

Enter an S line command in this column next to the object for which you want to see a list of relationships or add a relationship. The S line command is the only valid line command for this screen.

Object Name

Displays the names of Db2 objects that match the value specified in the DB2 Relationship Facilitator screen.

Relation Type

Displays the Relationship Type of the displayed objects.

AR	One or more Application Relationships exist for this object in the relationship file.
RI	One or more Db2 RI relationships exist for this object in the relationship file.
AR/RI	Both AR and RI exist for this object in the relationship file.
catalg	There are no relationships defined for this object in the relationship file. This status only applies when selecting option 3, Add AR.

SSID

Displays the ID of the Db2 subsystem from which the relationship had been defined or loaded.

Line Commands

The following File-AID for Db2-specific line command is valid on this screen:

S (Select)

Use the S line command to select an object for which you want to display relationship information or add a relationship. When loading RI for the object you select the DB2 RI Update Online Options Screen is displayed. When adding an AR for the selected object, the Object Type Selection Screen for Adding Application Relationship screen is displayed.