16.20 - Default Transform Group For a Structured UDT - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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.