Re: how to recreate queries

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.