Tandem ENFORM 058057, Справочное руководство

Страница: 193 / 312

WHERE Clause
Clauses
5–72
058057 Tandem Computers Incorporated
WHERE Clause
The WHERE clause allows you to restrict the records that contribute to the target file.
The syntax of the WHERE clause is:
WHERE logical-expression
logical-expression
is a condition that returns a true or false value. See Section 3 for more information
about logical expressions.
The logical expression in a WHERE clause defines which records are restricted from
contributing to the target file. For example:
WHERE employee; BEGINS WITH "BROWN";
Using the WHERE Clause
to Establish a Link
Using the WHERE clause to specify a link causes only the records which satisfy the
condition specified in the logical-expression to be included in the report. The link
created by the WHERE clause remains in effect only fro the associated LIST or FIND
statement. For a more complete description of linking, refer to the LINK statement in
Section 4. The following example shows how the WHERE clause is used to specify a
link:
WHERE parts.partnum EQ odetail.partnum,