Re: Finding files used by queries

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxxxxxxxx>]

Hi, Mike:

Jeff Yanoviak published an updated version of the late Gary Guthrie's original "RTVQRYF" utility in iSeriesNEWS magazine; Gary's original tool worked only at QSECURITY = 30 or below; Jeff's updated version works at any QSECURITY level.

Some time after that Jeff published a new "UPDQRY" tool that uses the virtual terminal APIs to sign-on and issue the WRKQRY command and options, based on an *OUTFILE created by the RTVQRYF command, so you can do a "mass update" of many queries, for example, to change the library name(s) of some the file(s) used by those queries..

See:       http://forums.systeminetwork.com/isnetforums/showthread.php?t=50138	for more details ...  Jeff Yanoviak replied to that thread (near the bottom).

Also, as of V6R1 and above, you can now issue DSPPGMREF to find what objects (e.g. *FILEs) a given *QRYDFN refers to. But, you must recreate the *QRYDFN at least once, after upgrading to V6R1, or after restoring a *QRYDFN from a previous release, in order to get this cross-reference information updated in the OIR of the library containing the *QRYDFN.  (Another excellent "use case" for Jeff's "UPDQRY" tool.)

I hope that helps.

All the best,

Mark S. Waterbury

> On 12/7/2010 10:08 AM, Mike Cunningham wrote:
> Is there a way to get a database export of all files used by all queries in a library?  Similar to a DSPPGMREF would give for an RPG application?  RTVQRYF does not appear to be around anymore.  We are at V5R4 (but don't wish to be)