RE: Determining what Logicals a PF has

I thought navigator required client access to be installed?


On Fri, 09 Dec 2005 12:13:31 -0400, Luis Rodriguez wrote
> 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
> 
> -- 
> http://www.fastmail.fm - Or how I learned to stop worrying and
>                           love email again
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) 
> mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To 
> subscribe, unsubscribe, or change list options, visit: 
> http://lists.midrange.com/mailman/listinfo/midrange-l or email: 
> MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment 
> to review the archives at http://archive.midrange.com/midrange-l.


If you bought it, it was hauled by a truck - somewhere, sometime.