Stored Procedures - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Stored procedures, which are called Persistent Stored Modules in the ANSI SQL-92 specifications, consist of a set of control- and condition-handling statements that provide a procedural interface to Teradata Database. These statements are specified using the Stored Procedure Language (SPL).

A stored procedure can be created from ODBC and some other client utilities, and stored within the user database on the Teradata Database server. It can be executed using the SQL CALL statement.

For a complete description of stored procedures and SPL, refer to SQL Stored Procedures and Embedded SQL (B035-1148).