UDT Attributes and Options - Teradata Administrator

UDT Attributes and Options

Table 21: Administer UDTs Dialog Box Description 

Field or Control Name	Description
Type Name	A list of all available UDTs. To create a new type, enter a new name.
Distinct	Select to clone an existing data type and add additional restrictions, or functionality, to the clone. 1
Structured	Select to create a data type with multiple fields.2
Array	Select to create an array type.
Comment	Type any descriptive text.

Examples

¹ Distinct data type: Define ‘Salary’ as a Decimal(9,2), but with a function that prevents someone from entering a value of less than 20,000 or more than 2,000,000.

² Structured data type: If ‘Address’ is defined as a UDT with sub-fields for Street, Apartment, City, State, and Zip Code, Transform functions must be provided that convert input and output data into and from an ‘Address’ object. Suggest inputting and outputting it as a string with all the fields concatenated, either using fixed field lengths or a delimiter such as a comma between them.

³ The following table demonstrates how the values entered in the Bounds text box are handled as SQL values.

Values entered	Result
10	CREATE TYPE MyInts AS Integer ARRAY [10]
1:5,10:20	CREATE TYPE MyInts AS Integer ARRAY [1:5][10:20]