16.20 - UDT_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

UDT_name

The name of the UDT, ARRAY, or VARRAY whose definition is to be altered.

SYSUDTLIB.
The specification of SYSUDTLIB is optional.
COMPILE
Do all of the following:
  • Recompile the code source for the specified type.
  • Generate the object code.
  • Recreate the appropriate .so file.
  • Distribute the recreated .so file to all nodes of the system.
Teradata Database replaces the existing type with the recompiled version.
COMPILE ONLY
Do both of the following:
  • Recompile the code source for the specified type.
  • Generate the object code.
If you specify COMPILE ONLY, Teradata Database does not generate or distribute the .so file.
The system does replace the existing type with the recompiled version.