17.10 - UDT_name / VARIANT_TYPE - 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)

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