Structured UDTs - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.