Re: Finding and replacing *QRYDFN

Hi, Jack:

When you upgrade to V6R1 from an earlier release, or restore *QRYDFN objects saved from a prior version of OS/400 or IBM i, cross-reference information is not automatically generated in the OIR for those queries. You must open each query with WRKQRY, then save it, to generate the cross-reference information.

Looking at Fix Central, searching for V6R1 PTFs with "QRYDFN" in the text description, I found this one that looks like the one alluded to in the V6R1 Memo to Users:

SI34166

Cover letter:
http://www-912.ibm.com/a_dir/as4ptf.nsf/ALLPTFS/SI34166

That cover letter explains how to use this tool to generate the "missing" OIR cross-reference information for queries created prior to V6R1.

Hope that helps,

Mark S. Waterbury

> On 7/3/2012 12:20 PM, Jack Kingsley wrote:

I ran a quick test on this, maybe someone can as well.
On a qrydfn that is post 6.1 I don't get much information using this
command.
On a new qrydfn created on 6.1 I do.


On Tue, Jul 3, 2012 at 12:17 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

Just as soon as I read Mark's post I remembered V6R1's Memo to Users...:-(

I stand corrected about using DSPPGMREF and QRYDFN..


Sorry for the mistake.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--




On Tue, Jul 3, 2012 at 11:37 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

Thanks, all I will look again in the morning. We are on V6.1 so I knew
it should work, and I tried running one of the QRY thinking it needed
that to get the information out of it.

2012/7/3 Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>:
> Hi, Dave:

What version of OS/400 or IBM i are you running on? At V6R1, IBM added
support for *QRYDFNs in the Object Information Repository (OIR) of each
library (*LIB), so you can now use DSPPGMREF to find cross-reference
information for queries. However, there are some "caveats" -- if I
remember correctly, you must either open each query with WRKQRY under
V6R1 and save it again, to get the (new) cross-reference information
generated, or I think there may have been a PTF or some special tool

you

could run that would populate that OIR information for you.

Also, some years ago, Jeff Yanoviak published a nice article in

NEWS/400

(iSeries News) illustrating how to "roll your own" cross-reference for
*QRYDFNs, and he also published a tool that uses a virtual terminal
session so you would not have to open each query and save it manually.

See:
http://archive.midrange.com/midrange-l/201006/msg00135.html

for details.

All the best,

Mark S. Waterbury

> On 7/3/2012 10:44 AM, Dave wrote:

Hi,

I need to take care of all the *QRYDFN on the system that use a file
I've modified.
I got the list by querying the output of DSPPGMREF on all the objects
on the system. All the QRY have the field WHSPKG = 'Q'

I copied all the QRY I found to my development library, and then using
wrkqry, I used option 2 + save to get them to use the new file format.
I copied them all back to the original libraries then I ran :

DSPPGMREF PGM(*ALLUSR/*ALL) OUTPUT(*OUTFILE) OBJTYPE(*QRYDFN)
OUTFILE(mylib/QRYDFN)

I'm only seeing one of the many QRY I modified in this outfile.


What am I missing or how should I have done this?

Thanks

--
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.

--
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.