• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

searching for file names on query definitions

Hello,

How can I search for a particular file name all the queries in a library?

thanks,

Don
0
dprice7
Asked:
dprice7
  • 2
2 Solutions
 
tliottaCommented:
Don:

Technically, you can't. At least, not without some MI programming. Or not without missing some file references such as output files.

I assume you mean *QRYDFN objects (all of which should have been deleted years ago and replaced with *QMQRY objects, but that's a whole other thread).

These are "compiled" objects that have no useful attributes that can be extracted by tools from IBM other than WRKQRY and perhaps RTVQMQRY with ALWQRYDFN(*YES) specified.

For many purposes, RTVQMQRY can help. It will take a *QRYDFN and convert it into a somewhat equivalent SQL statement that is then stored in a source member. The source member can then be scanned for file references.

Aside from IBM, I'm only aware of a couple variations on a tool named RTVQRYF. You search the web for it or find a .zip download of it through http://iseriesnetwork.com in the Tech Ceneter>Code lists.

Tom
0
 
RQnoneCommented:
The program I used and had very good luck with is RTVQRY from
http://www.qpratools.com/

As previously stated it is an MI program and because of that may not run at your security level.
0
 
tliottaCommented:
Minor note... The latest RTVQRYF from the late Gary Guthrie should work under security level 40, but I'm not certain that that's the one on iSeries Network.

Also, there is at least one derivative variation written in ILE RPG that I have seen and it also is not security-level sensitive, using only supported interfaces/APIs. I'd need to do some searching to track it down since I've long used my own custom version.

Tom
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now