UDF Source Code Contents | SQL External Routine Programming | Teradata Vantage - 17.10 - Source Code Contents - 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)
The topics that follow provide details about the contents of the source code for a UDF. In general, the contents of the source code must:
  • Define the SQL_TEXT constant
  • Include the sqltypes_td.h header file
  • Define the function parameter list in the order that matches the parameter passing convention specified in the CREATE FUNCTION statement
A C++ UDF or external procedure must catch all C++ exceptions by the end of the UDF or external procedure code. Any exception that is not caught and is thrown out from the routine may result in unexpected behavior.