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

ODBC Driver for Teradata® User Guide

ODBC Driver for Teradata
August 2020
User Guide

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.