17.10 - CREATE PROCEDURE Statement - 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)

To identify the file name and location of the source code and install it on the server, use the form of the CREATE PROCEDURE statement for external stored procedures. You can submit the statement the same way you submit the corresponding CREATE PROCEDURE for stored procedures, for example, by using the COMPILE command in BTEQ, but it is not required.

IF the external stored procedure … THEN the C/C++ function …
uses CLIv2 is compiled, linked to a CLI-specific external stored procedure dynamic linked library (DLL or SO) associated with the database in which the external stored procedure resides, and distributed to all database nodes in the system.
does not use CLIv2 is compiled, linked to a standard dynamic linked library (DLL or SO) associated with the database in which the procedure resides, and distributed to all database nodes in the system.

Note that other C/C++ external routines that are defined in the same database are also linked into the dynamically linked library.