Catalog views/trying to find object

[darkman0101]

Hi there,
I am trying to find a qry400 query on an iSeries running v5R2 that someone else wrote.

Is there a system table that I can query that will show object names, user descriptions/text etc?

Thanks in advance,
Jason

 

[leveyp]

Not sure that you can find a list of all Queries but the following is a good workaround:

use the command DSPOBJD (Display Object Description)
for *ALL objects in *ALL libraries with an object type of *QRYDFN. Direct to output to *OUTFILE and then use Query or SQL to examine the output