• Subject: Re: Interactive Query
  • From: Paul Tuohy <tuohyp@xxxxxxxxxxxxx>
  • Date: Thu, 11 Jan 2001 21:21:15 +0000

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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.