Return Values

Unlike all other database APIs, the values returned by 880-CALC-DBAG-<Index> are not part of the regular file record area. In fact, nothing related to the aggregate range routines alters the contents of the file record area in any way. All return values are dimensioned to the maximum allowable field size of 18 digits. The number of decimal positions is inherited from the database field. The naming convention for these return value fields is shown in the following table.

Field Description

DBAG-<Function>-<Index>-<FieldName>

You must code the SET prior to the call. See the following usage example, where <FUNCTION> is AVG, MAX, MIN, or SUM.

SET DB<FUNCTION>-<Index>-<FIELD> TO TRUE