17.10 - External Routines - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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.