Re: Join Logical File Problem

[Rajan.Srinivasan@xxxxxxxxxx]

Thanks  Andreas  to your response.   Out of your two possibility which you
have suggested,  I was trying to use
2nd one.  ( Because, I am not familliar with  MR ).   I  created using  all
three physical file into a joined Logical file.
But,  I was struck because Joined Logical File does'nt allow to  use
secondary file field as  a  Key field.

When I started working on this, I thouhgt I can use 19 different joined
Logical file with different key fields  to  replace  19 different OPNQRYF
which builds the access path every time we run the program.

But,  I cannot proceed further because of the joined Logical File
restriction , which does'nt allow to have key fields from
Secondary files.

Any help is  greatly  appreciated.

Regards
Raj







From: Andreas Kollwitz <andreas.kollwitz@duesseldorf.netsurf.de> AT
      Internet on 12-21-98 07:17 PM

To:   MIDRANGE-L@midrange.com AT Internet@ccmail
cc:    (bcc: Rajan Srinivasan/Servicing/SuperiorBank)
Subject:  Re: Join Logical File Problem




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







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