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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
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