transform_specification - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™
transform_group
A mandatory name for the transform group.
You can create or replace up to 16 transform groups per UDT. The first transform group you specify is the default transform group. A UDT cannot have two transform groups with the same name.
The name of a transform group cannot begin with the characters TD_, which are reserved as a transform group name prefix for internal use. For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
UDT transform names need not be unique across UDTs.
Transform group names are stored in DBC.UDTTransform, not in DBC.TVM.
TO SQL
The tosql routine maps a predefined data type value to a UDT value. The system invokes it automatically whenever a UDT value is transferred to Vantage from a client application.
Note that the external routine invoked by a tosql clause must be an external UDF. It cannot be a method.
FROM SQL
The fromsql routine maps a UDT value to a predefined data type value. The system invokes it automatically whenever a UDT value is transferred from Vantage to a client application.
The external routine invoked by a fromsql clause can be either an external UDF or a method.