Re: qry and dsppgmref

On 1/27/11 9:53 AM, CRPence wrote:

On 1/27/11 6:52 AM, David FOXWELL wrote:

<<SNIP>>

So now... How do I recreate all my QUERY without doing WRKQRY on
every library then selecting 2, F3, to save?

According to the V6R1 MTU, I visited the
http://www.ibm.com/eserver/support/fixes and searched for the
unquoted text "QRYDFN" and located the following PTF SI34166
providing a callable interface, the QQUIWHOI program, to add the
QRYFILE and OUTFILE Where-Used information from the Query/400 Query
Definitions into the OIR [Object Information Record] of *QRYDFN
objects in any one or all libraries:

http://www.ibm.com/a_dir/as4ptf.nsf/ALLPTFS/SI34166

Wow! Zero for two on good links. Sorry. I recalled having received some kind of redirection page versus an http 404 error, so I had thought the first link worked, even if just indirectly. However I figured out that rather than a redirect link, I clicked the "Support and Downloads" link offered, then signed in [with a no-cost IBM ID] which showed "Support for my selected products". However from there, the search bar was utilized with the "All support and downloads" enabled since searching only "IBM i 6.1" as the only choice for "supported products" for some reason does not actually locate that PTF by searching the token QRYDFN:
http://www.ibm.com/support/

So unfortunately the first link obtained from the MTU was incorrect; drop the "/fixes" and it should work to get to a generic support page, but then one must drill down to the IBM i OS fixes search page. Anyone who cares [for the sake of others] should probably submit an electronic reader comment to get the MTU 'corrected' to direct more appropriately.

As to why the second link does not work, I have no clue, but that was copied directly from the navigation bar of the browser. The following link should be functional to visit directly [presently being redirected to www-01.ibm.com], the PTF SI34166 cover letter providing "CORRECTION FOR APAR SE36403":
http://www.ibm.com/support/docview.wss?uid=nas3a7aab5b4c4a56c9d8625753d00631146

FWiW I can make no comment\recommendation for [nor against] the tool, as I neither wrote nor tested the function. I am only pointing out that such a tool exists.

Note: Any *QRYDFN restored from save taken on a prior release or a backup taken on the same release prior to the Query Definition having its Where-Used updated, the query will be restored without that OIR detail. That is because the function provided by the utility program named in the PTF is not also provided as an "object handler" for the *QRYDFN object type in the restore processing. The Query/400 product decided in its inception, not to have a restore handler, so restored queries also will never have a valid access plan. To update both the access plan and to get the OIR updated, then using a utility which drives the interactive WRKQRY prompts through 2=Change and 1=Save is probably a better choice overall [since effective screen scraping is the only means to update\compile a query definition, for lack of any compile\bind or create from source capabilities].

Regards, Chuck