Internal And External Representations Of Structured UDTs - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
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.