UDT Attributes and Options - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities
 

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

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

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

3 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]