Step 5—Selecting a relationship definition
File-AID/RDX displays the Relationship Listing pop-up window as illustrated in the following figure when, in the relationship file, it finds more than one object that matches the Table or File Name portion of the driving object (or when it finds only one Db2 table that matches the Table Name portion of the driving object, but the Creator portion does not match the driving object). In our example, we would have specified a different Creator ID to produce the resulting Relationship Listing.
Relationship Listing

To select the object with the relationship definition you want to use: | |
|---|---|
In this field… | Do the following: |
CMD | Type an S next to FRSAMP.ORDER_TABLE. |
Press Enter | File-AID/RDX displays the Extract Menu screen. Continue with Step 6—Extract Menu. |
Field Names and Descriptions
The following list describes all of the fields on this pop-up window.
FIELD | DESCRIPTION |
|---|---|
Multiple relationships exist for object | Indicates the Db2 table name or MVS file portion of the driving object specification for which File-AID/RDX found more than one match. |
CMD | Identifies the input field for the S line command. |
Object | Contains the names of the objects that match the name of the driving object you specified and that have relationships defined in the relationship file. |
SSID | Displays the subsystem ID of each Db2 table on the list. Not applicable for MVS objects. |
Primary Commands
The following list identifies the primary commands that are available from this pop-up window. For details on each command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
|---|---|
DOWN | Scrolls toward the end of the table list by the specified scroll amount. |
UP | Scrolls toward the top of the table list by the specified scroll amount. |
Line Commands
The following list identifies the line command that is available from this pop-up window. For details on the command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
|---|---|
S (Select) | Use this command to select one of the relationship definitions. |
Related topics