Thanks All...Re: Qshow field Headings
george.j.wen@us.abb.com
george.j.wen@us.abb.com
Fri, 19 May 2000 11:50:14 -0500
--0__=hQbQ3YcOo0y21RAsRl1tZYofIGKEwqFGjQffO02WqyZr7EGdpOKk32p1
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
Since Qshow is not configurable I think I'll get what I need by linking a file
with all my Files
and items in it to another with all my Elements and reporting by the file I
need. A already have
these files as I used them 'cleaning out' unwanted elements in my Dictionary.
I've done a lot
of cleaning due to the 16Meg file size limit on *USRSPC files on the 4000 -
that's what the
dictionary is (Can you Dec and HP guys can believe that?).
Thanks for your help.
(Embedded Michael Lee <Michael.Lee@mclsystemsinc.com>
image moved 05/19/2000 11:29 AM
to file:
pic08319.pcx)
Please respond to Michael.Lee@mclsystemsinc.com
To: Art Bahrs <ABahrs@denkor.com>
cc: "Heasman, David" <David.Heasman@seacontainers.com>, George J.
Wen/NB/USFAC/ABB@ABB_USFAC, powerh-l@lists.swau.edu
Subject: Re: Qshow field Headings
Security Level:? Internal
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.
--0__=hQbQ3YcOo0y21RAsRl1tZYofIGKEwqFGjQffO02WqyZr7EGdpOKk32p1
Content-type: application/octet-stream;
name="pic08319.pcx"
Content-Disposition: attachment; filename="pic08319.pcx"
Content-transfer-encoding: base64
CgUBCAAAAABQAB4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAABUQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAADpD9UPyg/FD8MPD8sPxQkPxQnMD8kJD8UJyA/KCQ/FCcUPwg8Pyw/FCQ/F
CcwPyQkPxwnGD8oJD8cJxA/CD8oPxgkPxgnLD8kJD8gJxQ/KCQ/HCQnDD8IPyg/GCQ/GCcsPyQkP
yQnED8oJD8cJwgnDDw/KD8YJD8YJyw/JCQ/JCcQPygkPxwnCCcMPD8kPxwkPxwnKD8kJD8kJxA/K
CQ/HCcIJww8PyQ/HCQ/HCcoPyQkPygnDD8oJD8cJwwnCDw/JD8cJD8cJyg/JCQ/KCcMPygkPxwnD
CcIPD8gPyAkPyAnJD8kJD8oJww/KCQ/HCcMJwg8PyA/ICQ/ICckPyQkPyQnED8oJD8cJwgnDDw/I
D8gJD8gJyQ/JCQ/JCcQPygkPxwnCCcMPD8cPyQkPyQnID8kJD8gJxQ/KCQ/HCQnDD8IPxw/JCQ/J
CcgPyQkPxwnGD8oJD8cJxA/CD8YPygkPygnHD8kJD8kJxA/KCQ/HCcIJww8P6Q/VD8oPxQ/DDw/F
D8sJD8sJxg/JCQ/KCcMPygkPxwnDCcIPD8UPywkPywnGD8kJD8sJwg/KCQ/HCcQJwg/ED8wJD8wJ
xQ/JCQ/MCQ/KCQ/HCcQJCQ/ED8wJD8wJxQ/JCQ/MCQ/KCQ/HCcQJCQ/ED8wJD8wJxQ/JCQ/MCQ/K
CQ/HCcQJCQ/DD80JD80JxA/JCQ/MCQ/KCQ/HCcQJCQ/DD80JD80JxA/JCQ/MCQ/KCQ/HCcQJCQ/C
D84JD84Jww/JCQ/MCQ/KCQ/HCcQJCQ/CD8kJyw/JCcMPyQkPywnCD8oJD8cJxAnCD8IPyQnLD8kJ
ww/JCQ/LCcIPygkPxwnECcIPD8kJzQ/JCcIPyQkPygnDD8oJD8cJwwnCDw8PyQnND8kJwg/JCQ/J
CcQPygkPxwnCCcMPDw/JCc0PyQnCD8kJD8cJxg/KCQ/HCcQPwg/JCc8PyQkPyQkPxAnJD8oJD8QJ
xQ/DDw/pD9UPyg/FD8MPDwwAAACAAAAAgACAgAAAAICAAIAAgICAgIDAwMD/AAAA/wD//wAAAP//
AP8A//////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=
--0__=hQbQ3YcOo0y21RAsRl1tZYofIGKEwqFGjQffO02WqyZr7EGdpOKk32p1--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.