Input Values

Field	Description
<Index>	You must specify the index in the statement.
Record retrieval variables (also known as `DB` fields)	Define the beginning and ending values of the last key by moving the appropriate values to the record retrieval fields named `DB-` <KeyFieldName> and `DBRNG-` <KeyFieldName>.
`WS-DB-SUB-RNG`	Identify the range key by moving the symbolic constant <IndexName>-<IndexFieldName> to WS-DB-SUB-RNG
DBAVG-<Index>-<FieldName> Average DBMAX-<Index>-<FieldName> Maximum DBMIN-<Index>-<FieldName> Minimum DBSUM-<Index>-<FieldName> Sum	Use a set of Boolean fields to identify the columns in the table to be returned and the aggregate function to be applied. These fields are named using the following convention: <Index> corresponds to and must match the Index that is specified in the 880-INIT-DBAG-<Index> and 880-CALC-DBAG-<Index> API calls. <FieldName> identifies the column to be aggregated You can request more than one column in a single API call by using the appropriate Boolean field several times with a different field name each time, and you may specify more than one function for each call.

<Index>

You must specify the index in the statement.

Record retrieval variables (also known as DB fields)

Define the beginning and ending values of the last key by moving the appropriate values to the record retrieval fields named DB- <KeyFieldName> and DBRNG- <KeyFieldName>.

WS-DB-SUB-RNG

Identify the range key by moving the symbolic constant <IndexName>-<IndexFieldName> to WS-DB-SUB-RNG

DBAVG-<Index>-<FieldName>

Average
DBMAX-<Index>-<FieldName>

Maximum
DBMIN-<Index>-<FieldName>

Minimum
DBSUM-<Index>-<FieldName>

Sum

Use a set of Boolean fields to identify the columns in the table to be returned and the aggregate function to be applied. These fields are named using the following convention:

<Index> corresponds to and must match the Index that is specified in the 880-INIT-DBAG-<Index> and 880-CALC-DBAG-<Index> API calls.

<FieldName> identifies the column to be aggregated

You can request more than one column in a single API call by using the appropriate Boolean field several times with a different field name each time, and you may specify more than one function for each call.