Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > HALT QUERY FROM

HALT QUERY FROM

Use the HALT QUERY FROM command to terminate a running query. You can specify the query by user ID or by node name. This command is useful for canceling a query operation that is monopolizing the server computer.

Restriction: This topic applies to Windows environments only.

Note:

The HALT QUERY FROM command affects only running queries--ones that are literally in process on the XDB Server at the moment the command is issued. It does not cancel queries that are not actively under execution; for example, ones in which the client is simply fetching records from a result table. A query in this state is active, but is not running on the server. To cancel a query in this state, you must terminate it from the client application or force the user off the system using the XDB Server Monitor.

Invocation

This command can be embedded in a host language or executed interactively.

Authorization

Any of the following

The owner of the query
A super user
A user with SYSADM or SYSCTRL privileges

Syntax

HALT QUERY FROM USER user-name

or ...

HALT QUERY FROM node-name

Parameters:

`user-name`	Is the user ID of the user (or program) that initiated the query. The HALT QUERY FROM USER command cancels all running queries for the specified ID. For example, if three users were each running a query program that logged on to the server using the same ID, all three queries would be canceled. If you need to cancel one specific user's query, use HALT QUERY FROM node-name instead
`node-name`	Is the name of the node from which the query was issued. To display a list of the active node names, use the XDB Server Monitor or query the Virtual Statistics table (XDBSTAT.USERLIST). Specify the entire name of the node as displayed by the XDB Server Monitor or listed in the Virtual Statistics table, including the :number part of the name