16.20 - Default and Temporary Paths - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
To manage external stored procedures, Teradata uses default and temporary paths for external stored procedure creation and execution, including:
  • A default directory that Teradata uses to search for source files and object files if the CREATE PROCEDURE does not explicitly specify the location.

    If a source file or object file is on the server and the path is not fully specified in the CREATE PROCEDURE statement, the full path of the file is expected to begin here.

    An administrator, or someone with sufficient privileges, is responsible for creating this directory.

  • A temporary directory where external stored 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.

  • A directory where Teradata saves the dynamically linked libraries.
  • A directory of shared memory files for external stored procedures that execute in protected mode.

For information, including the names of external stored procedure default and temporary paths, see Teradata Vantage™ - Database Administration, B035-1093.