Use the Halt Query option to stop the processing of any DML command (DELETE, INSERT, SELECT, and UPDATE). Halt Query is especially useful when a user's workstation hangs or when a potentially long query needs to be aborted.
If security is on, you must have SYSADM authority on the SYSTEM location (or have super user privileges) to perform this operation.
To halt a query: