AS/400 Query File Reference

540 pts.
Tags:
AS/400 Query
How would you go about identifying file, field and output references of a group or *all AS/400 queries? I need to be able to identify files where used in queries.

Answer Wiki

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

Hello,

This website has step by step instructions to run this

===========================================================

Unfortunately, the above link does not provide a reliable list. Files are often chosen at run-time by Query/400 queries. A “model” file is an example where the actual file is overridden at run-time; the model is created temporarily in order to create the query or as a renamed copy of a similar set of files.

And outfiles are most often not specified at creation at all but only named at run-time — they are only rarely captured by the referenced utility.

Field names are even less reliable.

Because of those and other concerns, there simply is no good way to process Query/400 queries to track file/field usage. The information is too often not in the queries.

Conversion to a QM query as in the linked utility loses additional information.

To gather all available information, the *QRYDFN object must be materialized and processed with MI routines or be processed as is done by these programs: One of the few reliable methods uses the RTVQRYF program. It uses ILE RPG to process the result of the USDMPQRY program — also ILE RPG. USDMPQRY is trickier to track down but can be found.

Tom

Discuss This Question:  

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following