From: cetz@cetz.rhein-main.de (Christopher Etz)
Subject: Re: How to cancel a running SQL statement

In article <315F18ED.2238@vtx.ch>, Frank BUFF  writes:
> I would like to know if it is possible to cancel a running
> SELECT statement (update/delete) without breaking the current
> connection to protect prepared statements and cursors.
> I try to do that from an ESQL program.
> 
> I guess it is not possible, but ISQL handles correctly CTRL-C

It is possible but AFAIK not documented.  There is a function IIbreak()
with the INGRES library, that does exactly what you are looking for.
You can call that function from a signal handler (typically catching
SIGINT or SIGALRM) or use it instead of an ENDSELECT.  The call takes
no arguments, and I'm not sure whether it returns a useful result.

	Christopher
-- 
________________________________________________________________________
Christopher Etz           Kopernikusstr. 28       D-65929 Frankfurt/Main
cetz@cetz.rhein-main.de   Tel.: +49 69 318091     Telefax: +49 69 318091

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William