17.20 - Asynchronous Operation - 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

The purpose of allowing multiple statements per connection is for the user to retrieve multiple result sets from a single connection. The application must allow the asynchronously executing function to complete before switching to another statement on the same connection (hdbc) and executing another function.

For multiple statements to execute in parallel asynchronously, the application must open a separate connection for each statement.

This operation is consistent with the “Executing SQL Statements” description in the Release 2 ODBC Programmer’s Reference specification on “Executing Functions Synchronously” (note 3).