RE: How to ID what queries use what files?

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

Yes but since the main purpose was to locate files used in the query the
WHERE vs LEFT OUTER JOIN doesn't matter...it's just searching for a file
name. 


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, December 21, 2006 2:35 PM
To: Midrange Systems Technical Discussion
Subject: RE: How to ID what queries use what files?

I'd be careful with RTVQMQRY.  It's a nice tool and I do use it but I'm 
not sure that it does an effective job with "matching records with
primary 
file".  Query/400 is really big on using the WHERE clause instead of a 
JOIN.  However, what you're looking for here is a LEFT OUTER JOIN.

Rob Berendt