16.20 - Initializing Storage - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
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;