Halt Query

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:

1. Press F8. A window containing AuthIDs (user names) and nodes appears.
2. Use the up-arrow and down-arrow keys to highlight the name of the user whose query you want to halt.
3. Press Enter. Confirm the action when requested.