Distinct UDTs - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
Product Category
Teradata Tools and Utilities

A distinct UDT is based on a single, predefined data type such as INTEGER or VARCHAR. It redefines an already-defined SQL data type.

Salary Example

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.