Re: Join Logical File Problem

[VENU YAMAJALA <venu_yamajala@xxxxxxxxxxxx>]

Hi Raj,

I am not trying to give you an answer to your problem. But it seems you are a
little confused!! The purpose of OPNQRYF and join logicals is almost similar. I
normally prefer OPNQRYF if the file is not too big!! If the file is too big, I
use join logicals. Replacing OPNQRYF with join logicals is not always
necessary. It depends on the files we use for it.

OPNQRYF generally looks for an exisitng access path. If it finds an access
path, it uses otherwise, it builds the access path. Building access path
dynamically is taking long time for you. You can avoid this time by already
creating the access paths outside. Whether you create 19 different logicals or
3 different PFs, is your design issue. But to reduce the time, better make
OPNQRYF use an existing access path.

Hope this helps.

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