You can cancel a request through an interface function. From Interactive SQL, you can cancel a request by clicking the Interrupt SQL Statement button on the toolbar (or by clicking SQL » Stop).

If you cancel a request that is carrying out a cursor operation, the position of the cursor is indeterminate. After canceling the request, you must locate the cursor by its absolute position, or close it.