HPlogo QUERY/iX Reference Manual > Chapter 4 QUERY/iX COMMANDS (cont)

MULTIFIND ALL

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

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.



MULTIFIND

MULTIFIND procedure