Re: RPG Web Service Architecture

["Haas, Matt (CL Tech Sv)" <matt.haas@xxxxxxxxxxx>]

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?