Final total-only processing

 

The Open Query File (OPNQRYF) command supports final-total-only processing. It is a special form of grouping in which you do not specify grouping fields. The output is only one record.

All of the special built-in functions for grouping can be specified. You can also specify the selection of records that make up the final total.

• Example 1: Final total-only processing
  This example shows simple total processing.

• Example 2: Final total-only processing
  This example shows total-only processing with record selection.

• Example 3: Final total-only processing
  This example shows total-only processing using a new record format.

 

Parent topic:

Selecting records without using DDS