Stored Procedures

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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).