15.10 - FOR UDT_name - Teradata Database

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