15.00 - External SQL Procedures and SQL - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

External SQL Procedures and SQL

You can execute SQL function calls from external procedures using either of the following languages and APIs.


FOR an external routine written in this language …

You can use this API to execute SQL calls …

  • C
  • C++
  • CLIv2



    This does not mean that you can embed SQL statements within an external procedure, only that you can use standard CLIv2 or JDBC function calls to the appropriate driver, which then translates those calls into SQL requests and submits them to the Parser for processing.

    Note: Teradata Database does not support SQL function calls for mainframe‑attached systems.

    See Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems or Teradata JDBC Driver User Guide for documentation of the available SQL function calls.