skip to main content
Application Considerations : Supported ODBC API Functions : SQLCancel

Try DataDirect Cloud Now


The DataDirect Cloud Driver for ODBC supports SQLCancel, which can be used to stop the execution of a statement, including any processing being done by the DataDirect Cloud 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 DataDirect Cloud 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.