16.20 - TRANSFORM - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Adds UDT transform groups to the profile.

data_type
Name of uder-defined data type (UDT).
group_name
Name of transform group for the data type.

Example: Adding UDT Transform Groups to a Profile

This example creates a profile that specifies the XMLD_STRUCT1INT transform group for the XMLD_STRUCT1 data type and the TD_JSON_VARCHAR transform group for the JSON CHARACTER SET LATIN data type.

CREATE PROFILE DR_PROF AS TRANSFORM (XMLD_STRUCT1 = XMLD_STRUCT1INT, JSON CHARACTER SET LATIN = TD_JSON_VARCHAR);

Usage Notes

You can specify up to 256 data_type-transform_group pairs for a profile.

If the UDT has a default transform group, the default transform group is used unless the user specifies a transform group.