×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Mike -
Also be aware that if a query uses the 'Unmatched Records' option, the
source created by RTVQMQRY will not have the exception join specified
correctly - you'll have to fix it.
- sjl
Mike wrote:
Is there a way to get a database export of all files
used by all queries in a library? Similar to a DSPPGMREF
would give for an RPG application?
RTVQRYF does not appear to be around anymore.
We are at V5R4 (but don't wish to be)
Then Martin wrote:
RTMQMQRY can retrieve the 'source' of queries if you use the
ALWQRYDFN(*YES) option. The result is a source file with the
equivalent SQL to match the query, which includes any referenced
files.
I wrote a routine (sometime in the last century and not looked at
since then, either) to extract the file info into a more useful table.
If you're interested the code (CL, PF & old RPG) is available here:
http://www.dbg400.net/foswiki/bin/view/DBG400/ClQRYXREF
http://www.dbg400.net/foswiki/bin/view/DBG400/PfQRYXREF0
http://www.dbg400.net/foswiki/bin/view/DBG400/RpgQRYXREF0
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
