External Procedure Location Paths and Linkage Information | Teradata Vantage - External Procedure Default Location Paths - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update
Product Category
Teradata Vantage™

External procedures expect information to be in certain default locations when they are created or performed.

The following list catalogs the default path locations used by external procedures for the following purposes:
  • Store procedure source files
  • Compile procedure source files
  • Store .so or JAR files
  • Store shared memory files

The following table identifies the default directory paths for these resources and activities.

File/Directories Linux Description
Header file /etc/opt/teradata/tdconfig/Teradata/tdbs_udf/usr/ The header file sqltypes_td.h must be specified with an include directive in the procedure source.

You can copy this file if you code or compile the procedure outside of the database.

Source directory path /etc/opt/teradata/tdconfig/Teradata/tdbs_udf/usr/ The default directory to search for source files.

If the source or object file is on the Teradata platform in this directory, then you can specify the relative path from this directory for any server components specified in the external name string.

This applies to all the following file types.
  • Include
  • Object

    This category includes JAR files.

  • Package
  • Source
Compiler path /usr/bin/gcc  
Linker path /usr/bin/ld  
Compiler temporary path /var/opt/teradata/tdtemp/UDFTemp/ Temporary directory where external procedures are compiled

Any files needed for the compilation process are moved here. This includes source files from the server or client as well as object and header files, if needed.

Temporary compilation directories only exist during the duration of a compilation.

UDF library path /etc/opt/teradata/tdconfig/udflib/ Read-only directory where dynamically linked libraries are stored.
UDF server memory path /var/opt/teradata/tdtemp/udfsrv/ Directory where shared memory files used for the execution of protected mode procedures are stored.
JAR library path /etc/opt/teradata/tdconfig/jarlib/ Directory where JAR file libraries are stored.