Executing SQL From External Stored Procedures - Advanced SQL Engine - Teradata Database

To execute SQL, a C or C++ external stored procedure can use CLIv2 and a Java external stored procedure can use JDBC.

A C or C++ external stored procedure can also call the FNC_CallSP library function to call a stored procedure that contains SQL.