16.20 - UDT_name / VARIANT_TYPE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

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,
   ... )
{  ... }