How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in which the input files cannot be found (often the case when such files are output files of other procedures/queries).

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

Processing your response...

Discuss This Question: 11 &nbspReplies

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

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

Thank you Martin. ANZQRY does not, however, give me the names of the output files in each query, including libraries, which is what I want. The loop will be done by reading an output file generated by the DSPOBJD command for objects of type QRYDFN.
Regards,
Rafi (221901)

Hi,
From the WRKQRY command option 6 prints the query definition to a spooled file - but I don't see any way to get the same print from the command line (RUNQRY runs the query as well and won't work unless the input file exists).
If you can find a way to start this option from a command then I think this should work for you. Otherwise you could always use WRKQRY and type 6's next to all your queries (not an ideal solution).
Regards,
Martin Gilbert.

See here:
http://archive.midrange.com/repository/extqrydef.htm
This code will do exactly what you want. Just write a CL to build the object list, and create the output file as described. You can then write a command definition to make it even easier to use.
Regards,
Sloopy

Yeah, sorry, 221901. It's the same at my place.
At least Modiyooch is happy! Insecure, but happy....
I'm going to look at doing this using DMPOBJ to dump the objects I need, and look at the dump output to find the data. It's long-winded, but will work at our enhanced security levels.
Regards,
Sloopy

OK. I have a version now that will work with security level 40.
I don't have a website, so I will have to give you my email address, thus breaking the unwritten code of the superhero and revealing my true identity. It's better that way than having all of you post your own email addresses here....
If you would like a zip file with the sources, write to me at:
john.blenkinsop@ne.nykline.com
Regards,
Sloopy

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

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