16.20 - External Procedure Default Location Paths - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

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 table on the following page documents 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.