Step 9—Specifying the Selection Criteria
File-AID/RDX displays the following figure when you select option 5 from the Extract Menu or exit from the Extract Scope screen when in flow mode as set in USER profile SAMPMENU.
Object Selection Criteria
COMMAND ===> SCROLL ===> CSR
Primary Commands: INSert, BACK, FORward, DEL, SOrt
Line Commands : S = Add/Update Criteria D = Delete Criteria
Driving Object: FRSAMP.ORDER_TABLE
SSID: DSN Location: DSNLOCAT Set 1 of 1
CMD Object Name Status
--- ---------------------------------------------- ---------------------------
_ DSNLOCAT.FRSAMP.CUSTOMER_TABLE
S DSNLOCAT.FRSAMP.ORDER_TABLE Driving
_ DSNLOCAT.FRSAMP.CONTACT_TABLE
_ DSNLOCAT.FRSAMP.ORDER_LINE_TABLE
_ DSNLOCAT.FRSAMP.PART_TABLE
_ DSNLOCAT.FRSAMP.SUPPLIER_TABLE
_ 'TSOID01.FRSAMP.SUPPLIER'
_ 'TSOID01.FRSAMP.CUSTOMER'
_ 'TSOID01.FRSAMP.ORDERTAB' Object Excluded
_ 'TSOID01.FRSAMP.CONTACTT'
_ 'TSOID01.FRSAMP.ORDERLIN' Object Excluded
S 'TSOID01.FRSAMP.PARTTABL' ALL object
** End of List **
To select the driving object for selection criteria specification: | |
|---|---|
In this field… | Do the following: |
CMD | Type S in the CMD column on the line corresponding to ORDER_TABLE to select it for selection criteria specification. |
CMD | Type S in the CMD column on the line corresponding to PARTTABL to select it for selection criteria specification. |
Press Enter | File-AID/RDX displays the Object Selection Criteria Specification screen. |
Field Names and Descriptions
The following list describes all of the fields on this screen.
FIELD | DESCRIPTION | |
|---|---|---|
SET 1 of 1 | This message indicates which selection criteria set of the extract request you are currently viewing, defining, or modifying. For example, set 1 of 6 means that the current set is set one out of a total of 6 sets. To switch to another set, or insert, or delete a set, use one of the set primary commands BACK, FORWARD, INSERT, REPEAT, or DELETE. | |
CMD | Identifies the input field for the S and D line commands. | |
Object Name | Contains the names of the objects in the extract. | |
Status | Displays one of the following messages: | |
Message | Explanation | |
Driving | Indicates this object is the driving object for the extract. | |
Driving with Criteria Spec | Indicates that selection criteria has been specified for the driving object. | |
Criteria Specified | Indicates that selection criteria has been specified for the object. | |
Object Excluded | The object has been excluded from the extract request. | |
Unrelated Object | Indicates an unrelated object that has been added with option 3, Unrelated Objects, for this extract request. | |
Col Mis xxxx | The named column is part of the RI or application relationship, but does not exist in the table you want to extract. | |
Object not found | The object does not exist. | |
Col Len xxxx | The column length for the specified column in the relationship file or extract request file is not the same as in the table you want to extract. | |
Col Typ xxxx | The column type for the specified column in the relationship file or extract request file is not the same as in the table you want to extract. | |
Selection Criteria Invalid | The selection criteria specified does not match the object. | |
Primary Commands
The following list identifies the primary commands available from this screen. For details on each command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
|---|---|
BACK | Displays the previous selection criteria set, going back towards set 1. |
DELETE | Deletes the current selection criteria set in an extract criteria file. |
DOWN | Scrolls toward the end of the list by the specified scroll amount. |
FORWARD | Displays the next selection criteria set in an extract criteria file. |
INSERT | Inserts a new selection criteria set after the currently displayed set. The new set’s id number equals the current set’s number incremented by 1. Example: current id = 3 of 5, id of inserted set= 4 of 6. Any following set id numbers in the criteria file are of course incremented accordingly, for example 4 of 5 becomes 5 of 6, 5 of 5 becomes 6 of 6. |
NEXT | Displays the Extract Criteria Information pop-up window. |
REPEAT | Repeats (duplicates) the current selection criteria set after the currently displayed set. The new set’s id number equals the current set’s number incremented by 1. Example: current id = 3 of 5, id of inserted set= 4 of 6. Any following set id numbers in the criteria file are of course incremented accordingly, for example 4 of 5 becomes 5 of 6, 5 of 5 becomes 6 of 6. |
SORT | Sorts the displayed list of object names by the specified sequence (column) name |
UP | Scrolls toward the top of the list by the specified scroll amount. |
Line Commands
The following list identifies the line commands that are available from this screen.
COMMAND | DESCRIPTION |
|---|---|
S (Select) | Use this command to select an object for which you want to add or modify selection criteria for the current set. When you use this command for a Db2 object, File-AID/RDX displays the Table Selection Criteria screen or the Extract Key File Specification window before the Driving Table Selection Criteria screen. However, if the extract request is a single Db2 table extract with Selective Columns and/or Delimited extract file, the Object Selection Criteria - Selective Columns screen displays. When you use this command for an MVS object, File-AID/RDX displays the Selection Criteria Menu screen. |
D (Delete) | Use this command to select an object for which you want to delete selection criteria for the current set. |
This section provides information about the following topics: