Re: Cancelling A query

Peter Wages wrote: > > We have a reoccurring situation where a user in dbaccess submits a query > against several large tables , changes his mind and cancels it with > control-c. This has brought down the database. We're using 7.14 UD1 on > an HP K460/T6600. Is there any way to prevent this? We have an 80 > gigabyte database. If interrupting a single session can bring down your database (I presume you mean your OnLine system) you have bigger problems. However, the easiest solution is for the 4GL programs to include the following: options SQL interrupt on Now, when the user pressed CTRL-C while the program awaits a query, the program will get an error message to the effect that "Query interrupted by user". (No, I don't know the error number! Do I look that kind of total twit? ;-) -- -- Jake (Never yelled "CROWDED THEATER!" during a fire) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+