AGGREGATETYPE attribute

The AGGREGATETYPE attribute defines how the aggregate field value is computed.

Syntax

AGGREGATETYPE = { PROGRAM | SUM | AVG | MIN | MAX | COUNT }

Usage

PROGRAM specifies that the aggregate value will be computed and displayed by the program code.

An aggregate type different from PROGRAM specifies that the aggregate value is computed automatically:

The SUM and AVG aggregate types apply to data types that can be used as operand for an addition, such as INTEGER, DECIMAL, INTERVAL.

The MIN and MAX aggregate types apply to data types that can be compared, such as INTEGER, DECIMAL, INTERVAL, CHAR, DATETIME.

AGGREGATE tot = FORMONLY.total, AGGREGATETYPE=PROGRAM;