Re: Join Logical File Problem

[Andreas Kollwitz <andreas.kollwitz@xxxxxxxxxxxxxxxxxxxxxx>]

> We actually want to elliminate this OPNQRYF because it builds the access
> path every time the user selects an option, which also takes a long time.

I can understand this wish. Often OPNQRYF or using SQL is a fast and easy way to
solve a problem but it is a little like a "break section" because of various
reasons. - Who cares.. ;-)

Now: really - I only realize two possibilities for your problem:

(a) creating needed LF to all PF and using "matching records" (yes: although
there are some who hate it ;-), yes: although there are some who find it to be
complicated (it is _not_... it is easier using MR than coding all level
structures by yourself :-) ; btw I only used MR once during my 8 yrs of
programming)

(b) avoiding the "takes a long time" by creating the "right" LFs for the PFs so
that u can presume that the "access path optimizer" of OPNQRYF can join the 
files
as u want them a.s.a.p.

Andreas K., Germany.

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