Hello unnamed person :)

I have done something similar to this before, as I recall, but didn't
attempt to inform the user the query had failed with a message panel. The
purpose in my case was to force users to send long running queries to batch

My suggestion would be to change the job to use the default reply - in fact
if you want to prevent the query running this would be the only way to do
it - if the message turns up on the screen the users will undoubtedly take
"I" to ignore it, thereby defeating the whole purpose of the exercise.

In my situation I was only interested in preventing queries from being run
interactively in WRKQRY (i.e. command 5 in query) so cancelling was not a
problem. I seem to remember that the guts of the message is displayed at
the bottom of the screen after the query "fails".

Bear in mind that you will need to change the query attributes back when
you exit your query function otherwise any other subsequent query type
functions (for instance OPNQRYF type activity - and probably SQL as well)
will be subject to your limit also. This may be somewhat disruptive
depending on your applications...

You should also alter the job message handling back to whatever the default
is if you change it, and remove your message file override.

In other words - set everything back to how it was before you started :)

Hope this helps - I'm on holidays and can't take a look at any systems I
have access to for more details as I am struggling to remember my password...

Evan Harris

>I have modified the Message CPA4259 in library MyLib and removed the reply
>If the resulting number of seconds from the Query Estimator is *LE than the
>&NbrOfSeconds ... let it execute
>without user intervention ...
>Send a Display/Panel (MyDsiplay)  to the user informing that the query will
>not run due to query time limitations
>The problem is ... I still get the *INQUIRY message ...
>If I introduce the CHGJOB command with the DFTRPY(*YES) parameter, the
>default in QSYS is Cancel the run ...

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.