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

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
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 .