Re: qry and dsppgmref

On 1/26/11 6:24 AM, David FOXWELL wrote:

I thought that at V6.1 DSPPGMREF on a program would show all the QRY
executed by that program. ?

What IBM i 6.1 provided additionally for the DSPPGMREF was to name a *QRYDFN [Query/400 Query Definition] object or a generic [name] on the PGM() parameter, for which by specification also of either the OBJTYPE(*ALL) or OBJTYPE(*QRYDFN [...]), the *FILE objects that the query or queries reference(s) will be included in the output of the request [but only if the *QRYDFN has been updated or created on\since v6r1].

Note: Because the special value *ALL for object type now includes that additional object type, generic names used for the PGM() parameter on previously coded DSPPGMREF OBJTYPE(*ALL) may see slower response and more records of output, as compared to when run on a prior release; to avoid the effect for when information about *QRYDFN is not desired, code explicitly which object types for which references should be extracted. The support and its possible impact to performance were to have been documented in the v6r1 MTU [Memo To Users]; I did not verify presently, but recall it was there, possibly even with a description of some means to update existing query objects to have the "where used" information added, without having to 2=Change and 1=Save from the interactive WRKQRY utility.

Regards, Chuck