Requests That Do Not Generate Result-Sets - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-08-22
dita:mapPath
xbl1544831938754.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

For requests that do not generate result-sets, when errors are encountered, ODBC Driver for Teradata sets the status value in the status array to SQL_PARAM_ERROR for the parameter set that failed and all the other elements are set to SQL_PARAM_DIAG_UNAVAILBLE, indicating that status is not available. This is because the request can execute in parallel and there is no way to determine which parameter sets were successfully executed before the failure occurred and the request was aborted.

The application can identify the failed parameter set and correct it if possible or resubmit the request with the failed set by marking it as SQL_PARAM_IGNORE in the operations array. The latter is more efficient than just submitting each parameter set one at time upon failures.