Enform Plus Reference Manual

Statements

Enform Plus Reference Manual—422684-001

4-16

FIND Statement

The FIND statement allows you to specify the input fields and records that contribute to

the target-record and either write output records to a physical file or transmit

output records to a host-language program. The FIND statement must end with a

semicolon. The syntax of the FIND statement is:

UNIQUE

is an option that prevents duplicate output records. UNIQUE adds processing

overhead and should be avoided unless you know unwanted duplicate records exist.

output-record-name

is the name of the dictionary record description of the output record.

output-field-name

is the name of a field in the dictionary record description of the output record.

Enform Plus allows you to qualify output-field-name. If you do not qualify

the name, Enform Plus qualifies output-field-name with output-

record-name. In either case, output-field-name must be sufficiently

qualified to avoid ambiguity between it and any other name specified in the query.

by-item

is an input field name. An input field name must be sufficiently qualified to avoid

ambiguity between it and any other name specified in the query. You cannot specify

more than 63 by-items for your query.

target-item

is an input field. Valid values for an input field are: a field name, a string literal

enclosed in parentheses, a predefined aggregate, a user aggregate, an arithmetic

expression, an IF/THEN/ELSE expression, a user table name, a user variable, or a

system variable. An input field name must be sufficiently qualified to avoid

ambiguity between it and any other name specified in the query.

logical-expression

is an expression returning a true or false value.

FIND [ UNIQUE ] output-record-name

{ { BY by-item } }

{ { BY DESC by-item } }

( { [ output-field-name := ] { target-item } } , ... )

{ { ASCD target-item } }

{ { DESC target-item } }

[ WHERE logical-expression ] ;