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 Teradata Vantage™ SQL Fundamentals, B035-1141 for the rules for naming database objects.
- 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);