Enform Plus Reference Manual

Enform Plus Reference Manual422684-001
5-1
5
Clauses
This section describes the syntax of the Enform Plus clauses. The clauses are specified
in alphabetic order.
Enform Plus clauses are components of statements. They provide additional
specifications of the Enform Plus program to be performed. Most of the Enform Plus
clauses remain in effect only for the query associated with the LIST or FIND statement
of which they are a part.
An Enform Plus program with a FIND statement produces records only; it has no report
features such as headings, titles, summary information, and special formatting. The
following clauses are applicable only to Enform Plus programs with a LIST statement
and cannot be used in programs with a FIND statement:
Table 5-1
lists the Enform Plus clauses and their functions.
AFTER CHANGE clause NOPRINT clause
AS clause PCT clause
AS DATE clause SKIP clause
AS TIME clause SPACE clause
AT END PRINT clause SUBFOOTING clause
AT START PRINT clause SUBTITLE clause
BEFORE CHANGE clause SUBTOTAL clause
CENTER clause SUPPRESS clause
CUM clause System Variable clauses
FORM clause TAB clause
FOOTING clause TITLE clause
HEADING clause TOTAL clause
NOHEAD clause WHERE clause
Several of the Option Variable clauses
Table 5-1. Enform Plus Clauses and Their Functions (page 1 of 3)
Field Selection, Grouping, and Sorting
Clause Function
ASCD and DESC Sort target-records in ascending or descending order,
respectively, according to the value of a specified field.
BY and BY DESC Group and sort target-records according to the value of a
specified field.
SUPPRESS Prevents certain records from being printed in the report, but does
not prevent the records from contributing to the report calculations.
WHERE Selects which records will contribute to the output.