dsppgmref -- how can I find objects used in Query400?

[Guest.Visitor]

Hi Sue. Try this. I got it from a Squad Leader of mine when I was in the Army. He has since been called up (yet again), but his legacy lives on. This gives you a list of the files used. It does not take into account any overrides that may or may not be in CLPs that call using RUNQRY. -Mean 1[*]** CL PROGRAM *** dclf queryfile dspobjd obj(mean1/*all) objtype(*qrydfn) output(*outfile) + outfile(mean1/queryfile) loop: rcvf rcdfmt(qlidobjd) monmsg msgid(cpf0000) exec(do) return enddo rtvqmqry qmqry(&odlbnm/&odobnm) srcfile(mean1/qtxtsrc) alwqrydfn(*yes) goto loop

[EDIguru]

dsppgmref -- how can I find objects used in Query400?

I have been using dsppgmref command to create a reference file so I can locate where objects are used. But I notice it will not tell me if, for instance, a file is used by a query. Is there any way to do this? My previous employer had a great software package for referencing where objects are used, but that's not an option here.

[andreas.goering@web.de]

dsppgmref -- how can I find objects used in Query400?

Hello All! I you are searching for a professional tool in managing Querys have a look at **QueryOptimizer** at www.goering.us . Regards Andreas Goering GOERING iSeries Solutions