skip to main content
Configuring Hybrid Data Pipeline Driver for ODBC : Application considerations : Supported ODBC API functions : SQLCancel
  

Try Now
SQLCancel
The Hybrid Data Pipeline Driver for ODBC supports SQLCancel, which can be used to stop the execution of a statement, including any processing being done by the Hybrid Data Pipeline connectivity service. Unlike when using SQLFreeStmt (SQL_CLOSE), any results generated before SQLCancel is called are still available for retrieval. Fetching past the generated results will return a statement-was-cancelled error. Refer to the ODBC specification for details on the usage of SQLCancel.
Note: Because the Hybrid Data Pipeline connectivity service may be accumulating results for a statement, canceling a statement is usually treated as if a function is running on another thread. Only if all results from the statement have been retrieved will it be considered that no processing is being done on the statement.