17.05 - UDT_name - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
Last Update
2021-01-22

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.
Vantage 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, Vantage does not generate or distribute the .so file.
The system does replace the existing type with the recompiled version.