Enform Plus Reference Manual

Statements
Enform Plus Reference Manual—422684-001
4-34
Request-Qualification
you must first understand what a group is. A group is defined in DDL as any field whose
level number (03, 04, 05, and so on) is less than that of the next field. For example,
consider the following DDL record description:
RECORD test.
FILE IS "$mkt.sample.test" key-sequenced.
02 account-num.
05 type PIC 9(4).
05 num TYPE BINARY 16.
02 custnum PIC 9(4).
end
Within this record, account-num is a group. The data type of a group is always
alphanumeric. When a group name is specified as a target-item within a LIST
statement, Enform Plus displays each field within the group as alphanumeric data. If one
of the fields within a group contains binary data, using a group name as a target-
item causes undesirable results. For example, specifying:
LIST account-num;
causes Enform Plus to display account-num without first converting it to a readable
form.
Request-Qualification
Use the WHERE clause to limit the records that contribute to the report. The WHERE
clause is described under WHERE Clause on page 5-72.
Conditional Printing
Use the SUPPRESS clause to define a condition or conditions that prevent specific
records from printing throughout a report. Enform Plus still includes the suppressed
records in AFTER CHANGE and BEGIN CHANGE clauses, subtotals, totals, and other
calculations specified for the report. Note that the value of the first record of an AFTER
CHANGE clause or the last record of a BEFORE CHANGE clause is used for the print-
list regardless of whether that record is printed. The SUPPRESS clause is described
under SUPPRESS Clause
on page 5-64.
Summary Reports
Summary reports contain only the first target-record from each group (created by a BY
or BY DESC clause) down to some level. Summary reports can be generated only by a
query that contains an aggregate.
The two methods of obtaining a summary report are:
•
Explicitly request a summary report by setting the @SUMMARY-ONLY option
variable to ON before issuing the LIST statement.
•
Implicitly request a summary report by specifying only by-items and aggregates
over by-items in the query.