Locates all entries in the data set regardless of the value of the
data item specified.
Syntax |
 |
F[IND] ALL [#LIMIT=i;] item identifier
|
For example:
Where item identifier'' = LABOR.BADGE#''
Where item identifier = F-NAME
Parameters |
|
- i
is an integer specifying the maximum number of qualifying entries
you want to retrieve. i must be >= 0. If you specify
a negative number, QUERY ignores your input. When the #LIMIT =
parameter is specified, only the first qualified entries are placed in
the select file. If fewer than i qualifying entries exist, then
all entries that qualify are placed in the select file.
- item identifier
takes the form:
[data base name:] [data set name.] data item name
|
data base name is the name of a data base specified in the last DEFINE,
DATA-BASE=, or MULTIDB command.
data set name is the name of the data set you want to access.
data item name is the name of any data item in that set.
Discussion |
|
If you want to locate all entries in a data set (and use these
entries in a report, for example), this is an easy way to do so.
If you do not specify data set name, QUERY will check the data
set list and follow the same rules as defined when using a FIND command
with a single data set. (Refer to the FIND command
for more information.)
Example |
|
>F ALL CUSTOMER.ACCOUNT
USING SERIAL READ
13 ENTRIES QUALIFIED
>R D,ACCOUNT,8;END
54283540
54283545
10293847
.
.
.
24536173
24566356
10034765
>FIND ALL LAST-NAME
USING SERIAL READ
13 ENTRIES QUALIFIED
|
Both FIND commands locate entries in the CUSTOMER data set. The REPORT command prints the value of ACCOUNT for each entry.
