HELP TRANSFORM Example | Teradata Vantage - 17.00 - Example: HELP TRANSFORM for a UDT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

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