ENFORM User's Guide

Selecting Information
Developing an ENFORM Query
3–24 058058 Tandem Computers Incorporated
Selecting Information The information selected for a report or a new physical file is called the target list. The
target list defines the elements that appear in the target records produced by the query
processor. Table 3-3 shows the statements that both identify the target list and tell
ENFORM whether to produce a report or a new physical file.
Table 3-3. ENFORM Statements Used to Select Information
Statement Function
LIST Selects information to be printed in a report.
FIND Selects information to be placed in a new physical file called a FIND file.
Producing a Report Use the LIST statement when you want to select information for a report. The LIST
statement selects the data base elements that contribute to the report, the data base
elements that are printed in the report, and the ordering of the report lines.
Remember to establish the query environment before issuing the LIST statement and
to link any necessary record descriptions either with a LINK statement or by including
a WHERE clause in the LIST statement.
Permissible target list elements for a LIST statement are: field names, literals,
arithmetic expressions, IF/THEN/ELSE expressions, user variables, user tables,
system variables, parameters, user aggregates, or predefined aggregates. Figure 3-9
shows an ENFORM query, indicates the target list elements, and shows the report
generated by the query.