Files used by queries

[NoseDive]

Does anybody know how I can retrieve a list of files used in a query definition (other than by printing the query definition).

I need to find out which queries run over a certain library/file. As we have a lot of queries in a lot of libraries I cannot go through each one individually. I have created, in a PF, a list of all *QRYDFN objects on the system and need to interrogate them all, retrieving the names of all files used.

I used to know of a propgram/API that did this, but have changed jobs and no longer have it (and can't remember what it was called)

Any help would be appreciated. Thanks.

 

[PeteJohnston]

I was scouting around looking for something else and found this link

http://www.news400.com/sharewarefiles/rtvqryf.zip

but I've not looked at it and I don't know exactly what it does. Hope it helps.

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[NoseDive]

Thanks - I forgot to mention that we are at security level 40. It would appear that this version has now been restricted to iseries News Pro VIP members only. I don't suppose anybody has downloaded this and would be kind enough to share it with me?

Thanks.

 

[Mercury2]

Give me your e-mail pls.

 

[NoseDive]

It's OK, I have passed this onto our software supplier, who will do it for us.

But thanks anyway.