Structured UDTs - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
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).

Address 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.