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

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 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);