The internal and external representations of structured UDTs are indicated in the following table:
|FOR this type of representation …||A structured UDT is stored in the following format:|
|internal||A concatenation of the data types of its individual attributes.|
|client||however, it is defined by its fromsql transform functionality.
See CREATE TRANSFORM and REPLACE TRANSFORM for details.
Client software does not see UDT values, but values having a predefined data type representing a UDT on the Teradata platform. How a platform UDT is transformed to a client predefined type is entirely at the discretion of the transform developer.
See the appropriate Teradata Tools and Utilities documentation for details of how a particular client application deals with structured UDTs.