Re: Finding files used by queries

[CRPence <CRPbottle@xxxxxxxxx>]

  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