RE: Display A Query Definition Question

["Rubino, Jim" <Jim.Rubino@xxxxxxxx>]

If you already let them do the RUNQRY command as you stated below, they are
only changing the data selection for the run they are doing and not in the
query definition itself.  If you only want them to run the query without
changing the selection that has been set up, then DO NOT include the
RCDSLT(*YES).  I could be missing what it is you are really trying to do or
accomplish.

Jim Rubino
Senior Business Systems Analyst
FIKE CORPORATION
704 South 10th Street
Blue Springs, Mo.  64015
(816) 229-6216  Ext. 213
 

-----Original Message-----
From: Bill Hopkins [mailto:BHopkins@xxxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, October 15, 2003 2:14 PM
To: Midrange Systems Technical Discussion
Subject: Re: Display A Query Defination Question

Thanks I was already using the 
RUNQRY QRY(MYLIB/MYQRY) RCDSLT(*YES)

and was trying to stop them from being able to change Query Selection. 
Guess I'll have to trust the users :( .

Thanks Again
Bill Hopkins





G Armour <garmour400m@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/15/2003 02:18 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Display A Query Defination Question


Bill, whoever can give a solution to your question will be like a god,
since IBM told me eons ago that the reason you are stuck with the current
WRKQRY (non-)interface was that "it is an end-user tool".  With logic like
that...

BTW, your question in its simplest form has been discussed before in the
list: http://archive.midrange.com/midrange-l/200306/msg01405.html

GA

--- Bill Hopkins <BHopkins@xxxxxxxxxxxxxxxxxxx> wrote:
> I have a subfile program that list the queries that use whatever value
> is 
> put in ScanFor field. Program Name, Fields or anything you want to look 
> for. My question is there a way to display the query defination with a 
> command like:
> 
>                               Work with Queries 
> 
> Type choices, press Enter. 
> 
>   Option  . . . . . .   5              1=Create, 2=Change, 3=Copy, 
> 4=Delete 
>                                        5=Display, 6=Print definition 
>                                        8=Run in batch, 9=Run 
>   Query . . . . . . .   TESTQRY        Name, F4 for list 
>     Library . . . . .     BHOPKINS     Name, *LIBL, F4 for list 
> 
> Would like to go straight passed this to the actual query so they may
> see 
> where things were used but not change. And do not want them to key
> values 
> on screen above. 
> 
> Right now it just mouse clicks from subfile record to blank WRKQRY 
> command. But looking for just display. 
> 
> Any ideas? 
> 
> Thanks 
> Bill Hopkins

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.