UDT_name - Advanced SQL Engine - Teradata Database

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.