15.00 - External Procedure and UDF .so and .dll Linkage Information - 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)

External Procedure and UDF .so and .dll Linkage Information

There is only 1 .so or .dll file per database per node per application category, which is shared by all external procedures, UDFs, and table UDFs of a given application category contained by a database.

The application categories are as follows.

  • Standard
  • Applies to all UDFs and table UDFs.

    Also applies to external procedures that do not use the CLIv2 or Java APIs to make SQL calls.

  • CLIv2
  • Applies to all external procedures that use the CLIv2 API to make SQL calls.

  • Java
  • Applies to all external procedures that use the JDBC API to make SQL calls.

    The system generates a separate .so or .dll file for each non‑Java application category. Java UDFs and external procedures do not generate .so or .dll files because their source code is contained within their associated JAR files.

    Whenever you create, replace, or drop an external procedure, the .so or .dll file for that database has to be relinked with all the other external procedure object files and then redistributed to all the nodes.