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. |