15.00 - Recompiling a UDT - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Recompiling a UDT

It might become necessary to recompile one or all of your UDTs. An example might be an upgrade or migration to a newer release.

Recompiling a UDT is a simple operation. All you must do is submit an ALTER TYPE request that does the following.

  • Specifies the name of the UDT to be recompiled.
  • Specifies the COMPILE option.
  • A successful ALTER TYPE … COMPILE request does the following things.

  • Recompiles the code source for the specified type.
  • Generates the new object code.
  • Recreates the appropriate .so or .dll file.
  • Distributes the recreated .so or .dll file to all nodes of the system.
  • Related Topics

    The following topics are all related to UDTs.

  • “CREATE TYPE (Distinct Form)” on page 746
  • “CREATE TYPE (Structured Form)” on page 758
  • “DROP TYPE” on page 814
  • “HELP TYPE” on page 972
  • “CREATE TYPE (Distinct Form” in SQL Data Definition Language Detailed Topics
  • “CREATE TYPE (Structured Form)” in SQL Data Definition Language Detailed Topics
  • “DROP TYPE” in SQL Data Definition Language Detailed Topics
  • “HELP TYPE” in SQL Data Definition Language Detailed Topics