SQLCancel
- Last Updated: March 6, 2025
- 1 minute read
- Hybrid Data Pipeline
- Version 4.6
- Documentation
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.