Re: How to ID what queries use what files?

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

There is a utility (DSPQRYF) that does this.  It's in iSeriesNetwork (or 
whatever Wayne's calling it today).  I use it whenever I have a project 
that changes a table because my boss (Lord love 'im) doesn't know how to 
program so he uses WRKQRY to build files and reports.


There was a glitch when we move from v5r1 to v5r3 because the internal 
layout changed in the query, but the author (forget his name now, sorry) 
sent out a fix.  It may be posted at the mag site now.


Just checked.  The name du jour is Systeminetwork.  Hey, IBM's not the 
only one that keeps changing names.  David was smart (not that that's 
any surprise) to call it midrange.com!


Just checked - again.  You have to be an "AS400" network professional 
member (dues paying).


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



GKern@xxxxxxxxxxxxxxxx wrote:

> Anyone have any ideas for an automated method of searching queries 
> (*qrydfn objects) to identify what files are used by the query?
>
> This is similar to say doing a pdm find-string for a file, but I also need 
> to review if there are existing queries that may be impacted by making a 
> change to the file.
>
> Thanks!
>
> Regards, Jerry
>
> Gerald Kern - MIS Project Leader
> Lotus Notes/Domino Administrator
> IBM Certified RPG IV Developer
> The Toledo Clinic, Inc.
> 4235 Secor Road
> Toledo, OH 43623-4299
> Phone 419-479-5535
> gkern@xxxxxxxxxxxxxxxx
>
>
> This e-mail message, including any attachments, is for the sole use of the 
> intended recipient(s) and may contain confidential and privileged 
> information. Any unauthorized use, disclosure or distribution is 
> prohibited. If you are not the intended recipient, please inform the 
> sender by reply e-mail and destroy this and all copies of this message.
>