15.10 - UDT_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 or .dll file.
  • Distribute the recreated .so or .dll 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 or .dll file.
The system does replace the existing type with the recompiled version.