16.20 - C Aggregate Function Using UDTs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

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

This example shows how to write an aggregate UDF that takes a distinct UDT argument and returns a distinct UDT argument. The predefined type on which the distinct UDT is based is VARCHAR(20000) and the UDF performs a concatenation on the aggregation group.