API to retrieve files in a SQL view's access path definition? -- MIDRANGE-L

× 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.

Subject: API to retrieve files in a SQL view's access path definition?
From: David Gibbs <dgibbs@xxxxxxx>
Date: Wed, 3 Apr 2002 09:16:53 -0600
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Folks:

A co-worker of mine is trying to analyze a SQL View to determine the files
used in it's access path.

He's been looking at the QDBRTVFD API, but cannot figure out what
information (if it's there at all) to retrieve.

The information we're trying to get shows up on a DSPFD as follows...

Access Path Description
  Access path . . . . . . . . . . . . . . . . :            Arrival
    Files accessed by logical file              PFILE
       File               Library              LF Format
       V4                 DEVAXMF              V6
       V5                 DEVAXMF              V6

Thanks!

david

--
David Gibbs
Sr. Software Engineer / R&D / MKS Inc., www.mks.com
Lombard, IL, USA; tel: 630-495-2108; fax: 630-495-3591
Build Better Software

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: API to retrieve files in a SQL view's access path definition? , Martin Rowe
Re: API to retrieve files in a SQL view's access path definition? , Vernon Hamberg

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.