Initializing Intermediate Aggregate Storage | Teradata Vantage - 17.10 - Initializing Storage - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

During the AGR_INIT aggregation phase, a UDF must initialize the intermediate storage pointed at by the returned pointer from the FNC_DefMem call.

For example, the following statements initialize the intermediate storage area in the standard deviation example:

s1->n     = 0;
s1->x_sq  = 0;
s1->x_sum = 0;