Step 4—Selecting the Driving Object
File-AID/RDX displays the Table List pop-up window as illustrated in the following figure if you entered an asterisk in the Table Name field on the DB2 Driving Object screen.
Table List
To select the driving table from the pop-up window: | |
|---|---|
In this field… | Do the following: |
CMD | Type an S next to FRSAMP.ORDER_TABLE. |
Press Enter | File-AID/RDX searches the relationship file for all the tables that match the value ORDER_TABLE. If there are more than one relationship definitions, the Relationship Listing window displays the list. Otherwise File-AID/RDX continues with the Extract Menu. |
Field Names and Descriptions
The following list describes all of the fields on this pop-up window.
FIELD | DESCRIPTION |
|---|---|
CMD | Identifies the input field for the S line command. |
Location | Indicates the remote location ID for the tables displayed in the table list. |
Creator | Displays the authorization ID of the owner of the sample tables that match the Creator ID (and the Table Name pattern) specified on the Extract Specifications screen. |
Table Name | Displays the names of the tables that match the Table Name pattern (and the Creator ID) specified on the Extract Specifications screen. |
Type | Identifies the types of objects displayed on the table list. Valid objects are TABLE, SYNONYM, VIEW, ALIAS, and ARCHV. |
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 Creator and Table Name list by the specified scroll amount. |
FIND | The FIND command searches through data in the display and positions the line with the next occurrence of the specified find-string to the first line of the displayed data. |
LOCATE | Searches the sorted column of the displayed list and positions the line with the first occurrence of the LOCATE value to the first line of the displayed data. If the list has not been sorted, enter a line number. |
SORT | Sorts the displayed list by the specified column name. After sorting a column you can use the LOCATE primary command in that column. |
UP | Scrolls toward the top of the Creator and Table Name 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 the driving table. |
Related topics