Interactive Query

["Greg Day" <greg_day@xxxxxxxxxxx>]

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