RE: Finding and replacing *QRYDFN

Jeff Yanoviak wrote a utility (RTVQRYF) for V5R3. The article can be found
at
http://www.iprodeveloper.com/article/rpg-programming/retrieve-query-file-inf
ormation-at-security-level-40-4338
or http://tinyurl.com/rtvqryf .
I think you have to have a Pro membership, but could be wrong about that.

I used it at a previous employer and it worked great. There was a change to
the *QRYDFN layout at V5R4 that broke it, but Jeff sent me the changes that
I needed to make to the program for that, but all of that got left behind
when I moved here.

Jerry C. Adams
IBM i Programmer/Analyst
When all else fails, read the instructions.
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, July 03, 2012 10:17 AM
To: Midrange Systems Technical Discussion
Subject: Re: Finding and replacing *QRYDFN

Dave,

AFAIK (at least with V5R3) you can't do a DSPPGMREF with *QRYDFN.

I seem to remember that a way to check the files used in *QRYDFN objects was
to run a RTVQMQRY and then search the source members for the desired
file(s). SOmething like:

RTVQMQRY QMQRY(MYLIB/MYQRY)
SRCFILE(TEMP_LIB/QRY_SOURCE)
ALWQRYDFN(*YES)

HTH,
Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries