RE: Determining what Logicals a PF has

Here's an answer that won't cost you any money...

http://www.itjungle.com/fhg/fhg092805-story01.html

API Corner: Database APIs

by Shannon O'Donnell

The code for this article is available for download.

If you want to gather some information about an OS/400 database, there are
several ways you can go about it. You could use the DSPFD (Display File
Description) command to display top level information about a file. Or you
could use the DSPFFD (Display File Field Descriptions) command to display
information about each field. However, neither command has a very convenient
method of getting the resulting information into a format that can be easily
used by your applications. To do that, you need to use the database
APIs...(more)



You can download a FREE utility that will give you this information and
much, much more...and you can also get the source code with it too so you
can learn to do it on your own.

:-)

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James H H Lampert
Sent: Friday, December 09, 2005 9:08 AM
To: Midrange Systems Technical Discussion
Subject: Re: Determining what Logicals a PF has 

Just about everybody on the List wrote something to the 
effect of:

> The DSPDBR command shows this.

My Fellow Geeks:

<shameless-plug>
I can only add that the DBR function of QuestView will not 
only do this with a nice, easy-to-understand chart, but 
will also backtrack to the based-on physical of a simple 
logical to tell you what other logicals share the same 
physical, and will even give you a list of the based-on 
physicals of a join or multiformat 
logical.</shameless-plug>

--
JHHL