Re: Finding and replacing *QRYDFN

Jack,

The Memo to Users V6R1 states that:

****
If you create and save a query definition from the previous release, it
works the same way when you restore it to V6R1. However, if you restore a
V5R4 query definition (*QRYDFN) onto V6R1, you will not get the where-used
OIR information unless you specifically convert the query definition in
V6R1. The query definition is not automatically converted when the system
is upgraded to V6R1. To convert the query definition, you will need to
apply a special PTF. Contact Fix Central, Database category for the PTF
number at the following Web site:

http://www.ibm.com/eserver/support/fixes/
****

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




On Tue, Jul 3, 2012 at 11:50 AM, Jack Kingsley <iseriesflorida@xxxxxxxxx

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.

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