• Subject: Interactive Query
  • From: "Greg Day" <greg_day@xxxxxxxxxxx>
  • Date: Wed, 10 Jan 2001 06:21:28 -0000

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 

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 

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


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.