Retrieves entries from a select file.
Discussion |
 |
This command provides a specialized kind of retrieval by selecting
subsets of previously retrieved entries. It operates in a similar manner to the
FIND command except that it searches only entries already in the
select file established by the most recent retrieval command.
All data items named in the SUBSET command must belong to the
data set(s) accessed in the most recent FIND or MULTIFIND command.
Up to 50 logical connectors (AND,OR) can be used in a SUBSET command.
Refer to "Logical Connectors" under the FIND command.
When the SUBSET command is entered, the current select file is saved
as a temporary file which can be restored and made accessible through
the use of the UNDO command. (Note: the SAVE command saves the current
select file as a permanent file.) The temporary select file is then
examined for the subset of entries you request. Those entries
that qualify are placed in the new current select file. If you use the UNDO command, you will no longer have access to those entries retrieved by the most recent SUBSET command.
Table 3-12 Retrieval Command Relational Operators
OPERATOR | MEANING |
---|
= IS IE EQ | is equal to (Multiple values may be used with these operators.) |
# <> ISNOT INE NE | is not equal to (Multiple values may be used with these operators.) |
< ILT LT | is less than |
>= INLT GE | is not less than (is greater than or equal to) |
> IGT GT | is greater than |
<= INGT LE | is not greater than (is less than or equal to) |
IB value1, value__2__ | is between (and including) value__1__ and value__2__ |
| Note: The operators <>, <=, and >= cannot have
any intervening spaces (embedded blanks).
|