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 |