Default and Temporary Paths - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢
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.