Retrieving Query Definitions
July 31, 2002 Timothy Prickett Morgan
Hey, Ted:
You mentioned in your article, “Print Query Definitions from a Batch Job,” in the May 22 issue of Midrange Guru, OS/400 Edition, a way of getting print definitions of Query/400 queries by using a process of RUNQRY and PRTDEF(*YES). This method didn’t help me much; I had too many queries and that meant too much processing time. I had to resort to manually printing the query definitions to an output queue, typing option 6s while in WRKQRY for each library. I was about to do the same for Query Management queries but I found the Retrieve Query Management Query (RTVQMQRY) command.
|
The RTVQMQRY command works for both *QMQRY objects and *QRYDFN objects. It creates a source member that I then can read in a program to extract the input and output files used in each query for a cross reference of files. I’m kind of excited about my discovery!
— Mary
RTVQMQRY does a good job, Mary. Just be aware that it won’t give you all the information that you get when you use option 6 of the Work with Queries (WRKQRY) command.
— Ted
Sponsored By ADVANCED SYSTEMS CONCEPTS
|
|
SEQUEL meets all your iSeries and AS/400 data access needs in a single, integrated solution:
Take 6 minutes to view a SEQUEL ViewPoint ScreenCam movie to see how simple Windows-based AS/400 and iSeries data access can be! In just a few short minutes, you can find out ways to make your job easier and improve data access throughout your organization. Download the ViewPoint movie here . For more information or a FREE trial of SEQUEL, call 847/605-1311 or visit Advanced Systems Concepts. |
