Re: Implicit Access Path Sharing

[Larry Bolhuis <lbolhui@xxxxxxx>]

Dave,

> >You want the process the file sequentially by key for
> >update but don't want to lock every record and lose
> >blocking.  You use one logical for IP and the second
> >for UF and CHAIN/UPDAT only when necessary.
> 
> James,
> 
> Could you not achieve the same thing without actually creating the second
> logical? You define it in your program, and at compile and run time you
> simply override it to the first logical.

  Yes you can BUT.  1) Personally I dislike having to have overrides
in place during compile.  You either end up with a custom
'Pre-compile' processor that does this for you, and custom CL to
compile that program, or you compile it on line so you can enter the
override (Bad Programmer, BAD BAD - 30 minute penalty with your
priority at 99!).  2) The second logical has virtually *zero
overhead.  It is merely a pointer and uses maybe 20K of disk.  3) It's
existance will help keep all uses of a second file within the same
program standardized.
  
   - Larry


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

-- 
Larry Bolhuis         | What do you want to reload today?
Arbor Solutions, Inc  | 
(616) 451-2500        | Two rules to success in life:
lbolhui@ibm.net       | 1. Never tell people everything you know.
+---
| 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
+---