17.10 - SQL Definition - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

Create the function definition with a parameter that has a VARIANT_TYPE data type.

CREATE FUNCTION add_int (p1 VARIANT_TYPE )
   RETURNS INTEGER 
   NO SQL
   PARAMETER STYLE SQL
   RETURNS NULL ON NULL INPUT
   DETERMINISTIC LANGUAGE C
   EXTERNAL NAME 'CS!add_int!add_int.c!F!add_int';