Re: Join Logical File Problem.

[Vanya Jovic <jovic@xxxxxxxxxxxx>]

On Tue, 22 Dec 1998, Buck Calabro/commsoft wrote:

> 
> 
> -snip-
> 
> >For the problem of building access path dynamically 
> >which takes long time, for that I am trying to 
> >replace LF   over  OPNQRYF.
> 
> -snip-
> 
> >Mr. David Duerr has suggested a solution by using 
> >SQL VIEW.  I am going to try that today.
> 

        As Buck mentioned, you need careful analysis and right logicals to
prevent QM from creating temporary index. SQL VIEW won't solve problem
because it will also use temporary index. But it will help you to find out
which logicals to create. Either STRDBG or CHGQRYA TimeLimit(0)(I'm not so
sure about right parm. name), then run VIEW, then carefuly read second
level messages in joblog. 

Vanya Jovic,
Canada

+---
| 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
+---