Re: API to retrieve files in a SQL view's access path definition?

[Martin Rowe <martin@xxxxxxxxxx>]

On Wed, 2002-04-03 at 16:16, David Gibbs wrote:
> 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

Hi David

I use the QUSRMBRD API to get referenced files information. If you want
an example see member DBG108R4 in my DBG/400 package -
http://www.dbg400.net/dbg400.html to get to the download.

Regards, Martin
--
martin@dbg400.net  jamaro@firstlinux.net  http://www.dbg400.net
/"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \
/
Source free test environment tools and others (file/spool/misc)
X
[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  /
\