AS/400 Outfile Different to Query Name

Tags:
AS/400
Outfile
I have an output file name but the creator of the query did not create the query with the same name. How can I search for the query that creates the output file? System being used is IBM iSeries.
1

Answer Wiki

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

Is this from a regular WRKQRY or a WRKQMQRY? Could it have been created from a data transfer ? You may have to put together a quick pgm to dump the qry definitions to a spool file,copy that to a flat PF record length 132 then scan the file looking for the output file name. The other option is to display every query and look for it manually. Depending on the number of queries you may have this may take a long time.

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.

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: