Ingres 2006 provides the ability to kill a query in another session while leaving the session in place. For more information, see the Command Reference Guide.