17.20 - SPL Compilation Errors and Warnings - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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

SPL compilation errors and warnings are reported by the 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.