How to find the list of queries (WRKQRY) using a PF

260 pts.
Tags:
AS/400
COBOL
DB2
WRKQRY
I want to list down all the Queries build using WRKQRY which are using a particular Physical File.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Unfortunately nothing is going to bee 100 percent correct. You could write a program to do it by asking for a print of the all of query definitions in all libraries. Then copy the spoolfiles generated to a combined database. The write a program to read this database and parse out the data.. it’s long, ugly and will still not give you everything you are looking for. You could then find the files being used.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: