16.20 - FOR UDT_name - 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

Name of the UDT associated with the transform group. This can be a structured or distinct UDT only. You cannot create transforms for complex data types such as ARRAY or XML.

See Teradata Vantage™ SQL Fundamentals, B035-1141 for the rules for naming database objects.

SYSUDTLIB
Optional specification of containing database.

Example: Creating a Transform Request

The following CREATE TRANSFORM request creates the transform group named client_IO, which is composed of the tosql transform stringToAddress and the fromsql transform toString for the UDT named address.

     CREATE TRANSFORM FOR address client_IO (
       TO SQL WITH SPECIFIC FUNCTION SYSUDTLIB.stringToAddress,
       FROM SQL WITH SPECIFIC METHOD toString);