External procedures expect information to be in certain default locations when they are created or performed.
- Store procedure source files
- Compile procedure source files
- Store .so or JAR files
- Store shared memory files
The following table identifies 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.
|
| 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. |