In interactive mode, you can cancel a command before it is completed by typing:
SQLHX
For example, you can cancel a query that is running and has not returned a query result. The SQLHX command drops the connection to the application server, thus canceling the current command and rolling back the current logical unit of work. If you issued an explicit CONNECT before the SQLHX command, the authorization ID and the name of the application server revert back to those defined by an implicit CONNECT: your VM ID and default application server.
| Note: | If you are using synchronous APPC/VM communications with the application server (by specifying the SYNCHRONOUS (YES) option when invoking the SQLINIT EXEC), the SQLHX command does not cancel the Database Services Utility command that is running. |