15.10 - Example: HELP TRANSFORM for a UDT - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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