|
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 knewyou
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
NEWS/400could run that would populate that OIR information for you.
Also, some years ago, Jeff Yanoviak published a nice article in
list(iSeries News) illustrating how to "roll your own" cross-reference forlist
*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
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
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.