Re: Finding files used by queries

Of course when merely extracting Lib/File name [i.e. not using the retrieved source to CRTQMQRY], the "join type" is of no consequence, since the layout of the retrieved FROM clause in the source member records remains identical for all of the Query/400 supported joins. More important potentially, be sure to use ALWQRYDFN(*ONLY) if the intent is to extract only the *QRYDFN named on the QMQRY [note: not a QRY] parameter; i.e. avoid accidentally retrieving the SQL statement of a *QMQRY object with the same name as a Qry/400 query definition object. Also FWiW, ANZQRY can be used to warn of conditions like "join type" not being supported.

Regards, Chuck

On 12/7/10 9:38 AM, sjl wrote:

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.

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