Re: qry and dsppgmref

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.