Re: Query scavenger hunt

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Dave

Create a PDM option that does the RTVQMQRY against the *QRYDFN objects. In 
WRKOBJPDM, press F17 to subset on object type, *QRYDFN. Then press F16 to 
create the user option. The command would, of course, be RTVQMQRY. Anywhere 
you need the query name, put in &N, anywhere you want the library name of 
the *QRYDFN, put in &L. Then in PDM put your option on the first *QRYDFN 
and press F13, then Enter, and there you go!

HTH
Vern

At 03:40 PM 11/15/2004, you wrote:




> Greetings,
>
> I believe that I've done this before but for the life of me I can't
> remember how.  I want to find what user queries use a given file.  I
> thought that I somehow used RTVQMQRY and then scanned the retrieved source
> for the file name.  Unfortunately, that only does one query at a time.  I
> might have written a program to do it for all queries in a given library
> but I was thinking that there was a way to do a bulk retrieval with just
> system commands.  Any ideas would be appreciated.  Thanks.
>
> Dave Parnin
> Nishikawa Standard Company
> Topeka, IN  46571
> daparnin@xxxxxxxxxxxxxxxxxx
>
> --
> 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.