16.20 - Example: HELP TRANSFORM for a UDT - 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

The following example reports the transform group name (client_IO ), predefined data type to which the UDT is converted (VARCHAR(40)), fromsql external routine name (toString) and tosql external routine name (stringToAddress ) for the UDT named address.

     HELP TRANSFORM address;
Group      Predefined Type from-sql            to-sql
------------------------------------------------------------------------
client_IO  VARCHAR(40)     SYSUDTLIB.toString  SYSUDTLIB.stringToAddress