- i
is an integer specifying the maximum number of qualifying entries you
want to retrieve. When the #LIMIT parameter is specified, only the first
i qualifying entries are placed in the select file. If
fewer than i entries exist, then all entries that qualify
are put in the select file.
- item identifier
takes the form:
[data base name:] [data set name. | dummy data set name.]
data item name [(subscript)]
data base name is the name of a data base specified in
either the DEFINE, DATA-BASE=, or MULTIDB command.
data set name is the name of a data set in the current
data base.
dummy data set name is a temporary data set name used in
multiple data set access (refer to the JOIN command).
data item name is the name of a data item contained in
the data base. If a data set name is used, the data item
must belong to the specified data set. To use the MATCHING option, the
data item must be type X or U.
subscript is a number indicating which sub-item to
access. Subscript must be an integer >= 1 and <=
the number of sub-items defined for the compound item. QUERY will default
to the first sub-item if no subscript is
specified.
- NO MATCHING
allows you to retrieve data based on all data records
NOT MATCHING the pattern provided.
The NO may be followed by additional characters such that all of
the following examples are accepted:
FIND PRODUCTS.NAME NO MATCH "ABC?*"
FIND PRODUCTS.NAME NOT MATCHING "ABC?*"
FIND PRODUCTS.NAME NONE M "ABC?*"
- MATCHING
allows you to retrieve data based on the comparison of data items with
a specified "pattern". Refer to the FIND command for a detailed
description of MATCHING.
- "pattern"
pattern must be enclosed in quotation marks. Refer to the FIND command
for further specifications.
- relation
takes the form:
[data base name:] [data set name. | dummy data set name.]
data item name [(subscript)] relop {"value" }[,{"value" }]
{$MISSING} {$MISSING} ...
data item name can be of any data type.
relop is a relational operator as shown in
Table 6-2 "Overpunch Characters".
value is the data item value. It must be the same type
and within the same value range as the data item named in the
relation. Value need not be enclosed in
quotation marks unless the value contains special characters. A
value which is not contained in quotation marks is
upshifted. For example, California is converted to CALIFORNIA before it
is compared to data item values in the data base. Value
must be an exact match for character type data items (type U and X). You
can use null values. Refer to "Using Null Values" under the FIND command.
$MISSING is used to retrieve a missing (non-compound) entry from
a compound data set. Refer to the MULTIFIND command for more
information.
- END
must be included in a procedure.