× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. February 2003

RE: Database Access Path Question

It depends on how many records meet the selection criteria. One factor that
will always favor dynslt is that data mgmt can select records much faster
than rpg code can.

accpth(*rebld or *dly) is another option.  Create standalone logicals w/o
dynslt.  If they are used once a week in batch or if conditions permit in an
online appl, tell the system to *DLY accpth maint or *REBLD the accpth with
the file is opened.

Steve

-----Original Message-----
From: midrange-l-bounces@midrange.com
[mailto:midrange-l-bounces@midrange.com]On Behalf Of David Dunfield
Sent: Thursday, February 06, 2003 10:12 AM
To: Midrange Systems Technical Discussion
Subject: RE: Database Access Path Question


DYNSLT may be an option, but we have experienced less than great
results using dynslt in reading records. It does work, but it still
reads all records in access path to select only those DYNSLT.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.