Checking for Stored Procedure Support - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Before creating a stored procedure, the ODBC application must first check whether the database supports stored procedures. This is done using the SQLGetInfo API to retrieve the details shown below. In all these cases, the term procedure means a stored procedure.

SQLGetInfo API specified with Returns
SQL_PROCEDURES (Y or N) Y = The database supports procedures

N = Not supported

SQL_ACCESSIBLE_PROCEDURES (Y or N) Y = User can execute all procedures returned by SQLProcedures

N = Some of the procedures returned are unavailable to the user

SQL_PROCEDURE_TERM (PROCEDURE) PROCEDURE in the database