15.00 - External SQL Procedures and SQL - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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

    Java

    JDBC

    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.