RE: Database Access Path Question

["Smith, Nelson" <NSmith@xxxxxxxxxxx>]

Thanks, Steve, Paul.

> -----Original Message-----
> From: Steve Richter [SMTP:srichter@autocoder.com]
> Sent: Thursday, February 06, 2003 1:21 PM
> To:   Midrange Systems Technical Discussion
> Subject:      RE: Database Access Path Question
> 
> logical L1:
>    K CmCusn
>    S CmDiv               Values('01')
> 
> Logical L2:
>    K CmCusn
>    S CmDiv               Values('02')
> 
> this will create 2 access paths.  Using DYNSLT the system creates 1
> accpth.
> 
> another way to go to create only 1 accpth is to move the select field into
> the keylist:
> 
> logical L1:
>    K CmCusn
>    K CmDiv
> 
> then use SETLL and READE in your code to just get records of a selected
> key.
> 
> 
> Steve
> 
> 


************************************************************************************************************************************************************************************************************
This message originates from Lincare Holdings Inc. It contains information 
which may be confidential or privileged and is intended only for the individual 
or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the 
contents of this message. 
All personal messages express views solely of the sender, which are not to be 
attributed to Lincare Holdings Inc., and may not be copied or distributed 
without this disclaimer. 
If you received this message in error, please notify us immediately at 
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************************************************************************************************************************************************