16.20 - CLASS - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Class of the function being defined.

Do not specify a keyword if the function class is scalar.

All row-level security policy UDFs must be scalar functions.

AGGREGATE
The function class is aggregate.
Do not specify this clause for scalar functions.
This clause is optional and can only be specified once per function definition.
interim_size
The size of the aggregate cache allocated for an aggregate UDF.
The minimum value is 1 byte.
The maximum value is 64,000 bytes.
The default value is 64 bytes.