UDT_name / VARIANT_TYPE - Advanced SQL Engine - Teradata Database

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.

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.

CREATE FUNCTION F1 (
  A VARIANT_TYPE )
RETURNS INTEGER
 ...;

void f1( UDT_HANDLE *a,
         INTEGER *result,
   ... )
{  ... }