Re: how to recreate queries

Hi, Chuck:

Thanks for the update and added details.

Note also (for the archives) that as of V6R1 and above, the OS now maintains cross-reference information (OIRs) for *QRYDFN objects, so that it is possible to determine what queries need to be updated when a given file has been changed. This information is available via the *OUTFILE of DSPPGMREF ... but unfortunately, this OIR information is not populated automatically when you upgrade from V5Rx to V6R1 or above, so it is also necesary to recreate each query one time, e.g. using Jeff's UPDQRY utility, to cause Query/400 to populate the cross-reference information.

All the best,

Mark S. Waterbury

> On 11/16/2013 1:25 PM, CRPence wrote:

On 15-Nov-2013 14:44 -0800, Mark S Waterbury wrote:

Jeff Yanoviak wrote a nice tool called UPDQRY that automates much of
this task, and published articles about it in NEWS/400 magazine.
See:
http://iprodeveloper.com/database/update-query-definitions-automatically

_i Update Query Definitions Automatically i_
Dec. 1, 2003 Jeff Yanoviak | System iNEWS Magazine
"This article is an expanded version of the December 2003 print-magazine
article.
Each addition of a new field — or even a change in field length for an
OS/400 file — means that all query definitions accessing that file must
be updated to avoid a level check. On a system with thousands of
queries, the task of identifying and resaving queries that are affected
by a file change is tedious at best. In May 2001, I published a utility
called DSPQRYD (see " Retrieve Query File Information at Security Level
40+," article ID 9925 at www2.systeminetwork.com), which handles the
first part of this task: identifying queries. This article includes a
follow-on utility I developed called UPDQRY, which takes the list of
queries generated by DSPQRYD and automatically updates them.
..."

and
http://iprodeveloper.com/database/retrieve-query-file-information-security-level-40

FWiW: The link just above, apparently was updated [ as copied from
the link in the former\current article] to:
<http://iprodeveloper.com/rpg-programming/retrieve-query-file-information-security-level-40>
_i Retrieve Query File Information at Security Level 40+ i_
Apr. 30, 2001 Jeff Yanoviak | System iNEWS Magazine
"OS/400 has lacked a query impact-analysis tool since its inception.
Fortunately, Gary Guthrie deciphered the relevant *QRYDFN object
internals and developed the MI program RTVQRYF, which lets high-level
language (HLL) programs determine both the input and output files
specified in a query. (You can download this utility at
http://www.as400network.com.) However, Gary's RTVQRYF works only at or
below OS/400's security level 30.

This limitation caused a dilemma for my company, which was striving to
reach security level 40. ...
..."

Some snippets included for more potential search keywords... for the
archives... and in case the links break [again], yet a copy might still
be found elsewhere with a web search.