15.10 - Checking for Stored Procedure Support - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

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 in Table 36. In all these cases, the term procedure means a stored procedure.

 

Table 36: Stored Procedure Support 

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