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