Re: Interactive Query

[Paul Tuohy <tuohyp@xxxxxxxxxxxxx>]

Hi Greg,

This has come up before. And (unexpected as it may seem) thats the way it works.

I gotta say that I hate to see users being stopped from using interactive query.
It is like giving someone a gift of a Porche and telling them that they can only
drive in 1st gear.

I know that queries on large files can adversely affect performance so better to
make use of the CHGQRYA command to limit the use of interactive query. Try the
following CL program.

-------------------------------------------------------------------------------------------

Dcl        &InqMsgRpy   *Char  10

RtvJobA    InqMsgRpy(&InQMsgRpy)

ChgJob     InqMsgRpy(*DFT)
ChgQryA    QryTimLmt(180)

wrkqry

ChgJob     InqMsgRpy(&InQMsgRpy)
ChgQryA    QryTimLmt(*SysVal)
--------------------------------------------------------------------------------------

This give them a maximum of 3 minutes for an interactive query. If you want to
emulate the "no interactive queries" then set the time limit to 0 instead of 
180.

If you are tempted to change the system value (QQRYTIMLMT I think) be very
careful. It also applies to OPNQRYF and SQL.

HTH

Paul Tuohy

Greg Day wrote:

> I have been asked to limit the interactive use of the RUNQRY command, and my
> results were unexpected. Can anyone offer an explanation.
>
> I created a library call B4SYS and placed this ahead of QSYS in the library
> list, by changing the QSYSLIBL system value. I then duplicated the RUNQRY
> command to this new library and changed the ALLOW parameter to remove
> *INTERACT.
>
> Now RUNQRY MYQRY from the command line now produces the expected message
> CPD0031 - "Command RUNQRY not allowed in this setting". Likewise, using F5
> in defining the query, or option 1 while exiting the query, produces QRY2294
> - "Specified option or F5=Report not allowed". So far, so good.
>
> For emergencies, I reasoned that I could still run query interactively by
> using the unchanged QSYS command. But, when I enter QSYS/RUNQRY MYQRY from
> the command line I get message QRY2294 - "Specified option or F5=Report not
> allowed". I didn't expect this. I thought that it would run the query
> interactively.
>
> Thanks for any help.
> Greg Day
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---