16.20 - Example: Using the ALTER TYPE Statement with the COMPILE Option - 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

The following example recompiles the UDT named address, generates the appropriate object code, generates the new .so library, and redistributes the file to all system nodes.

     ALTER TYPE address COMPILE;

The following example recompiles the one-dimensional ARRAY phonenumbers_ary, generates the appropriate object code, generates the new .so library, and redistributes the file to all system nodes.

     ALTER TYPE phonenumbers_ary COMPILE;