SPL Compilation Errors and Warnings - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Upon successfully completing the creation of a stored procedure, SQL_SUCCESS is returned to the client application.

SPL compilation errors and warnings are reported by Teradata Database as part of the SUCCESS return code only as a direct response to the CREATE PROCEDURE or REPLACE PROCEDURE request.

The application has to fetch the compilation errors and warnings with SQLFetch, followed by SQLGetData, until SQLFetch returns SQL_NO_DATA_FOUND.

If compilation errors are found, the stored procedure is not created or replaced.