HP 3000 Manuals HP 3000 Manuals
MULTIFIND ALL
Retrieves all compound entries from a compound data set specified by the
most recent JOIN command.
Syntax
MU[LTIFIND] ALL [#LIMIT=i;]
[ [data set name. ] ]
[[data base name:] [dummy data set name.] data item 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 i qualifying entries are
placed in the select file. If fewer than i
qualifying entries exist, then all entries that
qualify are put in the select file.
data base name is the name of a data base specified in either the
DEFINE, DATA-BASE=, or MULTIDB command, and named
in the most recent JOIN command.
data set name is the name of a data set used in the most recent
JOIN command. If data base name is specified, the
data set must belong to that data base.
dummy data set name is a temporary data set name established in the
most recent JOIN command.
data item name is a data item belonging to one of the data sets
named on the most recent JOIN command. If data
set name is specified, the data item must belong
to that data set.
Discussion
The MULTIFIND ALL command retrieves all data entries from a specified
compound data set resulting from a JOIN command.
>JOIN SALES-DETAIL.STOCK# TO&
>> INVENTORY-DETAIL.STOCK#
If you could look at the compound data set resulting from the above JOIN
command, it would appear like this:
<--------(SALES-DETAIL)--------> <---------(STOCK-DETAIL)-------->
------------------------------------------------------------------
ACCT# STOCK# QUAN STOCK# DESCR ON-HAND
------------------------------------------------------------------
111 50 100 50 NAIL 1000
111 60 20 60 BOLT 1200
------------------------------------------------------------------|
Example
Performing a MULTIFIND ALL on the data set SALES creates the compound
data set from which the following compound entries are retrieved:
>MULTIFIND ALL SALES-DETAIL.STOCK#
USING SERIAL READ
2 COMPOUND ENTRIES QUALIFIED
>REPORT ALL
TOOLS: SALES-DETAIL
ACCT# =111
STOCK# =50
QUAN =100
TOOLS: INVENTORY-DETAIL
STOCK# =50
DESCR =NAIL
ON-HAND =1000
TOOLS: SALES-DETAIL
ACCT# =111
STOCK# =60
QUAN =20
TOOLS: INVENTORY-DETAIL
STOCK# =60
DESCR =BOLT
ON-HAND =1200
Note that a REPORT ALL will show you the order that the data sets were
joined together. This may not be in the order that you specified them in
the JOIN command as QUERY optimizes the actual joining of the data sets.