15.00 - External Procedure Default Location Paths - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

External Procedure Default Location Paths

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 .dll, .so, or JAR files
  • Store shared memory files
  • The table on the following page documents the default directory paths for these resources and activities.





    Header file


    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


    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



    Linker path



    Compiler temporary path


    the 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


    the directory where dynamically linked libraries are stored.

    UDF server memory path


    the directory where shared memory files used for the execution of protected mode procedures are stored.

    JAR library path


    the directory where JAR file libraries are stored.