17.10 - Internal And External Representations Of Structured UDTs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)
Customers using Vantage delivered as-a-service cannot create their own C++ and Java UDFs, UDMs, UDTs, or External Stored Procedures.

The internal and external representations of structured UDTs are indicated in the following table:

FOR this type of representation … A structured UDT is stored in the following format:
internal A concatenation of the data types of its individual attributes.
client however, it is defined by its fromsql transform functionality.

See CREATE TRANSFORM and REPLACE TRANSFORM for details.

Client software does not see UDT values, but values having a predefined data type representing a UDT on the Teradata platform. How a platform UDT is transformed to a client predefined type is entirely at the discretion of the transform developer.

See the appropriate Teradata Tools and Utilities documentation for details of how a particular client application deals with structured UDTs.