 |
» |
|
|
|
|  | |
Retrieves all compound entries from a compound data set specified
by the most recent JOIN command. Syntax | |
MU[LTIFIND] ALL [#LIMIT=i;]
[ [data base name:] [data set 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)--------> <--------(INVENTORY-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. |
