Checking for Stored Procedure Support

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

Before creating a stored procedure, the ODBC application must first check whether Teradata 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 = Teradata 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 Teradata Database