17.10 - CREATE FUNCTION Statement - 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)

Use the CREATE FUNCTION statement to identify the file name and location of the source code and install it on the server.

The function is compiled, linked to the dynamic linked library (DLL or SO) associated with the database in which the function resides, and distributed to all database nodes in the system.

Note that all the UDFs and external stored procedures that are defined in a specific database are linked into a single dynamically linked library.