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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™
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.