× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



In the context of using a CGI program, you can set the script time out in the HTTP server. That will kill the CGI job when it runs longer than the time you specify.

For general DB access via SQL, you can change some settings in QQAINI (I know I spelled it wrong) that will put some limits on query execution.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Thorbjørn Ravn Andersen
Sent: Friday, December 12, 2008 2:24 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] RPG Web Service Architecture

Maurice O'Prey skrev den 12-12-2008 17:02:
One nice feature of keeping the responsibility for collecting iSeries
data on the . Net server is the ability to set the command timeout value

So if someone issues an SQL statement that doesn't complete in say 30
milliseconds an exception is thrown and you can inform ( or tell ) the
user to refine their search criteria

Yes. An extra layer is very nice, but you still need to stop the SQL
statement. What is the appropriate way to do that, or must it run to
completion?




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.