System Requirements | External Routines | Teradata Vantage - System Requirements - 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™

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.