Qshow field Headings

[Michael Lee]

Hi George. I just got to thinking about this and it toggled something in my
memory. I'm not sure it will work but you can try it out.

Because of the way the metadata works on the AS/400 you can access most AS/400
database files as subfiles using the open name. This means if your filename is
TEST_FILE and it's physical open name is LIBL/TESTFILE you can go into QUIZ or
QTP and enter this:
ACCESS *LIBL/TESTFILE

If you then do a SHOW ITEMS it may or may not show the headings.

You may or may not be able to use the LIBL. If not try to name the actual
library where the data file resides.

Good luck.


Michael Lee
MCL Systems Inc.


Art Bahrs wrote:

> Hi All :)
>     um... I may have misunderstood the original question...(and no... it
> definitely wouldn't be the first time). But when I want to know about a
> file/record/elements I check the source file for the dictionary.... *AND* I
> check what the reality of the database is with either Adager or SuprTool
> (QueryNM works too :) )
>
>     This lets me see everything I need to see and shows if the designer of
> the dictionary redefined any fields in the database and/or if there are any
> fields/flags inside of other fields ... I got this habit from a boss long
> ago who always said 'the database is reality... programs are filters' :)
>
> Art "what do you mean Image says it's zoned? hehehe" Bahrs
>
> ----- Original Message -----
> From: Heasman, David <David.Heasman@seacontainers.com>
> To: <george.j.wen@us.abb.com>; <powerh-l@lists.swau.edu>
> Sent: Friday, May 19, 2000 2:20 AM
> Subject: RE: Qshow field Headings
>
> >
> >
> > >From: george.j.wen@us.abb.com
> >
> >
> >
> > > Ahoy there!  I've got a question.  In using Qshow (SHOW RECORDS
> > filename) it
> > > nicely shows you the
> > > field name, type, etc.  Is there a way to make it show you the
> > field heading.
> >
> >
> > Hello sailor,
> >
> > This is deliberate; PowerHouse makes a real distinction between
> > Items in a file and Elements, ie between the physical and the logical.  It
> > aids clear design thinking.
> > To get the full info on an element you'll have to "SHOW ELEMENT...
> > "
> >
> > Sorry.
> >
> > Dave H
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> > Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> > Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> > This list is closed, thus to post to the list, you must be a subscriber.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.