UDT_name / VARIANT_TYPE - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

C Data Type Definition

typedef int UDT_HANDLE;

Usage

Use the UDT_HANDLE data type when passing a distinct or structured (including dynamic) UDT argument or returning a distinct or structured UDT.

Here is an example using a UDT in a UDF definition and UDT_HANDLE in a C function declaration.

SQL Function Definition Equivalent C Function Declaration
CREATE FUNCTION F1 (
  A circleUDT )
RETURNS circleUDT
 ...;
void f1( UDT_HANDLE *a,
         UDT_HANDLE *result,
   ... )
{  ... }

Here is an example using a dynamic UDT in a UDF definition and UDT_HANDLE in a C function declaration.

SQL Function Definition Equivalent C Function Declaration
CREATE FUNCTION F1 (
  A VARIANT_TYPE )
RETURNS INTEGER
 ...;
void f1( UDT_HANDLE *a,
         INTEGER *result,
   ... )
{  ... }