Re: qry and dsppgmref

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Uffda! [pun much appreciated]

You're right, Chuck - when someone says query, I don't think queries 
from query definitions - I think of query management or embedded SQL. 
Hence, my reply. Now I thought there was an addition to DSPPGMREF to 
display the files named in embedded SQL - might be all wrong there and 
haven't researched it.

Vern

On 1/27/2011 11:29 AM, CRPence wrote:
> On 1/26/11 6:44 AM, Vern Hamberg wrote:
> > Did you look at the help text for the command? You would have seen
> > right at the start that the command shows OBJECTS referred to by the
> > program. Queries are not objects. I think it will list the objects
> > used in queries, if known or knowable.
> >
> > On 1/26/2011 8:24 AM, David FOXWELL wrote:
> > > I thought that at V6.1 DSPPGMREF on a program would show all the
> > > qry executed by that program. ?
>     If by "qry", *QRYDFN was meant, then indeed each of such "Queries" is
> an "object" in the IBM i OS Vernacular [pun intended :-) ].  From the
> supporting text, admittedly it seems clear that Vern did not mean to
> imply that "Queries [Definitions] are not objects."  Instead meaning to
> suggest only that the Query [Definition] external object type is not
> named in the command help text as one of the "system objects provided"
> for as output of the command.  The *QRYDFN is not itemized with any of
> the supported "programs types" listed.