16.20 - Introduction - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

You can store executable procedures in the Teradata Database and invoke them later using the SQL CALL statement. There are two types of stored procedures:

  • SQL, consisting of statements written in the SQL Stored Procedure Language (SPL).
  • External, consisting of statements written in a standard programming language such as C, C++, or Java, and able to call CLIv2.

Refer to SQL Stored Procedures and Embedded SQL (B035-1148) for additional information on stored procedures.