15.10 - CLASS - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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.