• Subject: Re: How To Find Out What Outfile a Query Produces.
  • From: "Greg Day" <gregday@xxxxxxxxxxxxxxx>
  • Date: Wed, 8 Sep 1999 11:54:41 +1000

You wrote:
>I am involved in a project which has to convert a large number of user
>queries into programs, by reserve engineering them.
>The problem I have is that many of the queries use files for input that
>been created by other queries.
>As there are more than 4000 queries I am having trouble finding which
>queries output the file I'm looking for.
>Can anyone come up with something that will let me list the details of
>queries (including their output info.) into a file.

Use the RTVQRYF tool. The source can be downloaded from NEWS/400 code (if
you can find it). If you cannot find it I can send it to you as an
attachment to your email address.

This program will return the input and output files that are used in a
query. You could DSPOBJD YOURLIB/*ALL *QRYDFN  to an out file and have this
program process each query definition, outputting the returned variables to
a file which you could query.  A very useful tool.

Hope this helps

Greg O. Day

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].