15.10 - Distinct UDTs - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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

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.