HP 3000 Manuals HP 3000 Manuals
FIND ALL
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:
>FIND ALL LABOR.BADGE#
Where item identifier = LABOR.BADGE#
>F ALL F-NAME
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.