15.10 - Structured UDTs - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

A structured UDT is a collection of fields called attributes, each of which is defined as a predefined data type or other UDT (which allows nesting).

Example  

If Address is defined as a UDT with sub‑fields for Street, Apartment, City, State, and Zip Code, provide Transform functions to convert input and output data into and from an Address object. Input and output data as a string with all the fields concatenated, using fixed field lengths or a delimiter such as a comma between them.