17.20 - 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.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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.