External 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

An External Stored Procedure is written in a language other than SQL, and is defined by the ANSI SQL: 1999 standard. ODBC support of Teradata Database External Stored Procedures (XSP) is transparent to the ODBC user, and should have no effect on existing user applications.

The full specification of the syntax, format, and rules for both creating and invoking XSPs is beyond the scope of this document. See SQL External Routine Programming (B035-1147) for details on how to create and invoke user-defined functions.

XSPs are similar to UDFs except the CALL statement is used in the same manner as a stored procedure to invoke an XSP.