Hello everyone

I have the following challenge/opportunity/problem ....

I have created a new command WRKQRY in a Library named: MyLib,
This command has its own CPP (MyPgm in library: MyLib)

This CPP is a CL program that has these two key statements

(1) CHGQRYA QRYTIMLMT(&NbrOfSeconds)

I have a copy of the *MSGF QCPFMSG in library: MyLib

I am trying to do the following - I do not want the user to receive the
message ID CPA4259 at all


(2) OVRMSGF QCPFMSG to MyLib/QCPFMSG

Here is the actual description of the CPA4259 message description


 Message ID . . . . . . . . . :   CPA4259

 Message file . . . . . . . . :   QCPFMSG
   Library  . . . . . . . . . :     MYLIB
 Message . . . . :   Estimated query processing time &1 exceeds limit &2
 Cause . . . . . :   The database query time limit attribute has been
specified
   by the CHGQRYA CL command.  The query time limit specified is &2
seconds. A
   database query was about to be started which was estimated to require a
   longer time to run than that allowed by the query time limit attribute.
The
   estimated time is &1 seconds.
 Recovery  . . . :   Type a C to cancel processing of this query, or type
an I
   to continue processing the query.
 Possible choices for replying to message . . . . . . . . . . . . . . . :
   C -- Cancel the running of the query.
   I -- Ignore the query time limit and run the query.
 Technical description . . . . . . . . :   The following information
explains
   the type of access plan used by the query. This information is similar
to


More...

etc ... etc .. etc

I have modified the Message CPA4259 in library MyLib and removed the reply
options/values/defaults

If the resulting number of seconds from the Query Estimator is *LE than the
&NbrOfSeconds ... let it execute
without user intervention ...
Otherwise
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 ...

How can I get around this ?

If I introduce the CHGJOB command with the DFTRPY(*YES) parameter, the
default in QSYS is Cancel the run ...

Any other ideas ?


Just a query brain teaser ....




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.