Time Limit on Queries

[Leo Lefebvre <leo@xxxxxxxxx>]

Hi,

I changed the System Value QQRYTIMLMT to 300 (seconds) to limit the
query runs to about 5 minutes. 

In the interactive environment, the user gets the message CPA4259 when
the query is about take longer than the time limit, with the option to
continue or cancel the request. That works fine.

But when the request is executed in batch mode, the message gets
AUTOMATICALY the default reply 'C', not allowing anyone to enter a
reply. The only messages sent are 1) the user receives a message saying
that the system operator received a message, and 2) the system operator
receives a message saying the 'previous cl command failed' with options
C, D, I, and R. The reply to this message, obviously, will not allow the
job to run regardless of the time limit, but will either cancel/ignore
the query request (options C, D or I) or retry the same query request
(option R) with the same parameters, just to get the same results.
Unless, before replying with an 'R', somebody change the system value to
a greater number.

What would be the best way to operate, when the job is a 'batch' type,
to allow someone (the user or the system operator) to use his/her
judgement to kill the request or to continue.
We do have many programs with OPNQRYF and I would appreciate if I would
not have to modify all of them!


TIA

-- 
Leo Lefebvre
leo@tug.on.ca
Toronto Users Group for Midrange Systems
Ph: (416) 606-5960   ---   Fx: (416) 495-0100
                           
                            _/
                           _/
          _/          _/_/_/_/_/    _/_/_/
         _/          _/           _/    _/
        _/          _/          _/       _/
       _/          _/_/_/_/    _/       _/
      _/          _/          _/       _/
     _/          _/          _/       _/
    _/          _/           _/     _/
   _/_/_/_/_/  _/_/_/_/_/_/   _/_/_/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---