RE: Determining what Logicals a PF has

Also, you can use the iSeries Navigator and get a nice chart of the
relationships a PF may have (And it's free, too :-)

Best Regards,

Luis Rodrigues
Caracas, Venezuela

> 
> ------------------------------
> 
> message: 11
> date: Fri, 9 Dec 2005 09:27:33 -0600
> from: "Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxx>
> subject: 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
----------------
  Luis Rodriguez