System Requirements | External Routines | Teradata Vantage - 17.10 - System Requirements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

Before you can install or invoke external routines, your system must meet certain requirements.

IF you are developing … THEN your system must have …
UDFs, UDMs, or external stored procedures written in C or C++ a C or C++ compiler on the server that Teradata uses to compile the external routine.
a C or C++ external stored procedure that uses CLIv2 to directly execute SQL a current version of CLIv2 on all PE nodes that will execute the external stored procedure.
Java UDFs or external stored procedures a C compiler on the server that you use to execute the DIPSQLJ script from the DIP utility.
the Teradata JRE package on all nodes that will execute the Java UDF or external stored procedure.

The JRE installation path is a global configuration setting that you can view or modify using the cufconfig utility. For information, see Teradata Vantage™ - Database Utilities, B035-1102.

a Java external stored procedure that executes SQL a Teradata Driver for the JDBC Interface on the nodes that will execute the external stored procedure.

For more information on the Teradata Driver for the JDBC Interface, see Teradata JDBC Driver Reference, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html.