In Open SQL, you can use cancel() either to cancel the current result set or to cancel the execution of the current statement.

Method RWDBOSql::cancel(RWDBOSql::Current) cancels the current result set. For asynchronous connections, this will cancel the currently available result set (a result set is available when RWDBOSql::isReady() returns true). If no result is pending on an asynchronous connection the behavior is undefined. This call will block until the cancel operation is complete.

Method RWDBOSql::cancel(RWDBOSql::All) cancels the current statement execution. No subsequent results will be available from the command after this call has been made. This method can be used to cancel asynchronous executions. This call will block until the cancel operation is complete.