Object Selection Criteria panel
The following panel is displayed when you select Option 5 - Selection Criteria on the Extract Menu.
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: LOCATION Set 1 of 1
CMD Object Name Status
--- ----------------------------------------------- --------------------
_ FRSAMP.ORDER_TABLE Driving
_ FRSAMP.CONTACT_TABLE Object Excluded
_ FRSAMP.CUSTOMER_TABLE
_ FRSAMP.ORDER_LINE_TABLE
_ FRSAMP.PART_TABLE
_ FRSAMP.SUPPLIER_TABLE Object Excluded
_ 'TSOID01.FRSAMP.CUSTOMER' Unrelated with Criteria
** End of List **
Use this screen to perform the following tasks:
- Define one or more selection criteria sets for this extract.
- View or modify the list of objects from which File-AID/RDX will extract data.
- Select objects for which you want to specify or delete selection criteria.
This screen lists all objects that are part of the extract, including all unrelated objects specified with Option 3 - Unrelated Objects in the Extract Menu and all excluded objects. If there are more objects on this list than will fit on this screen, you can scroll the list up and down using standard scrolling commands. For more information about scrolling, see Scrolling.
In addition to the screen title, the Command field, and the scroll amount input field, the top area of the screen contains
- The name of driving object for the extract request
- Db2 subsystem ID and remote location ID if the extract includes Db2 objects
The body of this screen consists of:
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
Specify whether you want to:
- Add or modify selection criteria (S line command), or
- Delete selection criteria (D line command) for a given object
Object Name
Displays a list of objects from which data is to be extracted. When you use existing extract criteria with Db2 tables this column contains the creators associated with the tables listed in the extract criteria file. Otherwise, this column contains the creator associated with the object driving the extract.
Status
Displays the status of the objects to be extracted. The following messages are informational:
Message | Explanation |
|---|---|
Driving | Indicates the object selected to drive 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. |
All object | Indicates a related object with status ALL. |
All object with Criteria | Indicates that selection criteria has been specified for the related object with status ALL. |
Unrelated Object | Indicates an unrelated object that has been added with option 3 - Unrelated Objects, for this extract request. |
Unrelated with Criteria | Indicates that selection criteria has been specified for the unrelated object. |
The following messages indicate errors. You must correct these errors before proceeding with the extract.
Message | Explanation |
|---|---|
Col Mis xxxx | The named column is part of the RI or application relationship, but does not exist in the object 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 criteria 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 criteria 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. |
Line Commands
The following File-AID/RDX-specific line commands are valid on this screen:
D (Delete)
Deletes existing selection criteria for the specified object.
S (Select)
Use this command to create new selection criteria or update existing selection criteria.
- When the object is a Db2 table, S invokes the Db2 Object 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 is displayed.
- Invokes the MVS File Selection Criteria screen when specified for an MVS file (see Selection Criteria Menu).
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this screen:
BACK (BA)
Displays the previous selection criteria set in a criteria file (see also Object Selection Criteria). There are no operands associated with this command.
DELETE
Deletes the current selection criteria set in a criteria file. Valid only on the Selection Criteria Specification Screen when defining or modifying multiple selection criteria sets (see Object Selection Criteria). There are no operands associated with this command.
END
Returns to the previous screen. Any newly specified selection criteria will not be saved. There are no operands associated with this command.
FORWARD (FOR)
Displays the next selection criteria set in a criteria file. Valid only on the Selection Criteria Specification Screen when defining or modifying multiple selection criteria sets (see Object Selection Criteria). There are no operands associated with this command.
INSERT (INS)
Inserts a new selection criteria set after the currently displayed set in a criteria file. 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. Valid only on the Selection Criteria Specification Screen when defining or modifying multiple selection criteria sets (see Object Selection Criteria). There are no operands associated with this command.
REPEAT (REP)
Repeats (duplicates) the current selection criteria set after the currently displayed set in a criteria file. The new set’s id number equals the current set’s number incremented by 1. Example: current id = 1 of 5, id of inserted set= 2 of 6. Any following set id numbers in the criteria file are of course incremented accordingly, for example 2 of 5 becomes 3 of 6, 3 of 5 becomes 4 of 6, etc.. Valid only on the Selection Criteria Specification Screen when defining or modifying multiple selection criteria sets (see Object Selection Criteria). There are no operands associated with this command.
SORT (SO)
Sorts the displayed list of object names by the specified sequence (column) name. Valid SORT sequences are:
N
(Object Name)
ST
(Status)
This section provides information about the following topics: