Default Transform Group For a Structured UDT - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

Unlike the case for distinct UDTs, the system does not create a default transform group for a newly created structured UDT. However, you must create a transform group for a new structured type before you can use it as a column type for a table or use it in conjunction with operations involving the import or export of data defined with that structured type. If you attempt to use a new structured UDT without first defining a transform group for it, the request aborts and the system returns an error to the requestor.

To define a transform group for a new structured UDT, use the CREATE TRANSFORM statement. See CREATE TRANSFORM and REPLACE TRANSFORM.

To determine if a structured UDT has a defined transform, use the HELP TYPE statement. See HELP TYPE.