16.20 - External Routines - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
ANSI SQL defines the following family of SQL-invoked routines:
  • Procedures.
  • User-defined functions.
  • User-defined methods.

The ANSI SQL:2008 standard categorizes these SQL-invoked routines as either external routines or SQL routines.

An external routine is a user-defined function (UDF), method (UDM), or procedure that is written in an external, that is, non-SQL language such as C or C++, while SQL routines are written entirely in the SQL language.

When an external routine associated with a UDT is invoked, the system passes a handle to the UDT argument instead of passing the UDT value. Given the handle, the external routine can either retrieve or set the value of a UDT argument by means of a set of library functions provided by Teradata for this purpose. For more information, see Teradata Vantage™ SQL External Routine Programming , B035-1147 .