15.00 - External Procedure Default Location Paths - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.

     

    File/Directories

    Linux

    Description

    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

    /opt/teradata/tdat/tdconfig/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

    /opt/teradata/tdat/tdtemp/UDFTemp/

    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

    /opt/teradata/tdat/tdconfig/tdsplib/

    the directory where dynamically linked libraries are stored.

    UDF server memory path

    /opt/teradata/tdat/tdtemp/udfsrv/

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

    JAR library path

    /opt/teradata/tdat/tdconfig/tdsplib/

    the directory where JAR file libraries are stored.