Qshow Text Output
Latimer, Richard
richard.latimer@airways.co.nz
Wed, 25 Jun 2003 08:18:42 +1200
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C33A8D.CEB40590
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Jim,
=20
try the following (PH6.07 on as/400) BTW spot the bug in the report date
:-)
=20
=20
cheers
Richard
=20
=20
"set report device disk <name>"
"show element" will get you this:
=20
25/06/20103 Aviation Traffic Database and Billing Pag
E L E M E N T S U M M A R Y =20
For DICTIONARY: ATDB =20
=20
Element Name Type Size Dec Signif Output Pictur
=20
ADDRESS_LINE1 Char 40 "=AC=AC=AC=AC=AC=
=AC=AC=AC=AC=AC=AC=AC
ADDRESS_LINE2 Char 40 "=AC=AC=AC=AC=AC=
=AC=AC=AC=AC=AC=AC=AC
ADDRESS_LINE3 Char 40 "=AC=AC=AC=AC=AC=
=AC=AC=AC=AC=AC=AC=AC
ADDRESS_LINE4 Char 40 "=AC=AC=AC=AC=AC=
=AC=AC=AC=AC=AC=AC=AC
ADDRESS_LINE5 Char 25 "=AC=AC=AC=AC=AC=
=AC=AC=AC=AC=AC=AC=AC
ALT_LOWER Num 3 0 1 "=AC=AC=AC" =
=20
Usage: ALT =20
ALT_REQFLTLVL Num 3 0 1 "=AC=AC=AC" =
=20
Usage: ALT =20
ALT_REQFLTLVL_CHAR Char 3 "=AC=AC=AC" =
=20
=20
=20
"show element detail" will get all the above plus this for each element:
=20
Element: WGT_MCTOWSPCL =20
Usage: WGT =20
Type: Numeric =20
Size: 8 =20
Item Defaults: INTEGER SIGNED Size 4 =20
Heading: "Acft Int'l wgt" =20
Label: "Aircraft MCTOW Int'l (kg)" =20
Help: =20
"Enter aircraft MCTOW special (kg) - max 8 numeric. =20
=20
Description: =20
This is normally set to the same value as aircraft MCTOW=20
except where different weights are used for Domestic and=20
international flights. =20
The billing system uses MCTOW special instead of MCTOW =20
in the calculation of charges for International flights.
=20
=20
Values: 0 TO 99999999 =20
=20
Picture: "=AC=AC,=AC=AC=AC,=AC=AC=AC" ( BWZ ) =
=20
Input Scale: 10 =AC 0 =20
Output Scale: 10 =AC 0 =20
Leading Sign: "-" =20
Significance: 1 =20
=20
Records: AIRCRAFT =20
=20
=20
-----Original Message-----
From: Grace, Jim [mailto:Jim.Grace@ottawa.ccac-ont.ca]=20
Sent: Wednesday, 25 June 2003 7:01 a.m.
To: 'powerh-l@lists.swau.edu'
Subject: Qshow Text Output
Hi all, is there a way using Qshow to output the Elements of the database to
a text file, I'm sure I've done this before but I don't see it in any
Powerhouse manuals.
=20
Thanks in advance
=20
Jim
**********************************************************************
This electronic message together with any attachments is confidential. If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************
------_=_NextPart_001_01C33A8D.CEB40590
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2712.300" name=3DGENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25i=
n; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003>Jim,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D924360720-24=
062003>try=20
the following (PH6.07 on as/400) BTW spot the bug in the report=
date :-)</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003>cheers</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003>Richard</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003></SPAN></FONT><FONT face=3DArial color=3D#0000ff=
size=3D2><SPAN class=3D924360720-24062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D924360720-24=
062003>"set=20
report device disk <name>"</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D924360720-24062003><STRONG>"show element" will get you=20
this:</STRONG></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><FONT=20
face=3D"Courier New">25/06/20103 &=
nbsp;=20
Aviation Traffic Database and=20
Billing =20
Pag<BR> &n=
bsp; =20
E L E M E N T S U M M A R=20
Y &n=
bsp; =20
<BR>  =
; &n=
bsp; =20
For DICTIONARY:=20
ATDB  =
; =20
<BR>  =
; &n=
bsp;  =
; &n=
bsp;  =
; =20
<BR>Element=20
Name  =
; =20
Type Size Dec Signif Output=20
Pictur<BR>  =
; &n=
bsp;  =
; &n=
bsp;  =
; =20
<BR>ADDRESS_LINE1 &nbs=
p; =20
Char =20
40 =
"=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC<BR>ADDRESS_LINE2 &n=
bsp;  =
; =20
Char =20
40 =
"=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC<BR>ADDRESS_LINE3 &n=
bsp;  =
; =20
Char =20
40 =
"=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC<BR>ADDRESS_LINE4 &n=
bsp;  =
; =20
Char =20
40 =
"=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC<BR>ADDRESS_LINE5 &n=
bsp;  =
; =20
Char =20
25 =
"=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC=AC<BR>ALT_LOWER =
&nb=
sp; =20
Num 3 0 &n=
bsp;=20
1 "=AC=AC=AC" <BR> &nb=
sp; =20
Usage:=20
ALT =
&nb=
sp; =
&nb=
sp; =20
<BR>ALT_REQFLTLVL &nbs=
p; =20
Num 3 0 &n=
bsp;=20
1 "=AC=AC=AC" <BR> &nb=
sp; =20
Usage:=20
ALT =
&nb=
sp; =
&nb=
sp; =20
<BR>ALT_REQFLTLVL_CHAR  =
; =20
Char =20
3 =
"=AC=AC=AC"</FONT> </FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D924360720-24062003><FONT face=3DArial color=3D#0000ff=20
size=3D2><STRONG>"show element detail" will get all the above plus this for=
each=20
element:</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=3D924360720-24062003><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D924360720-24062003><FONT face=3D"Courier New" color=3D#0=
000ff=20
size=3D2> Element: &nbs=
p; =20
WGT_MCTOWSPCL &n=
bsp;  =
; =20
<BR> Usage:  =
; =20
WGT =
&nb=
sp; =
=20
<BR> Type: =
=20
Numeric &n=
bsp;  =
; =20
<BR> Size: =
=20
8 &n=
bsp;  =
; &n=
bsp; =20
<BR> Item Defaults: INTEGER SIGNED Size=
4 &=
nbsp; =20
<BR> Heading: &nb=
sp; =20
"Acft Int'l=20
wgt"  =
; &n=
bsp;=20
<BR> Label:  =
; =20
"Aircraft MCTOW Int'l=20
(kg)" &nbs=
p; =20
<BR> Help: =
&nb=
sp; =
&nb=
sp; =20
<BR> "Enter aircraft MCTOW special (kg) - max 8=20
numeric. =20
<BR>  =
; &n=
bsp;  =
; &n=
bsp;  =
;=20
<BR> Description:  =
; &n=
bsp;  =
; &n=
bsp; =20
<BR> This is normally set to the same value a=
s=20
aircraft MCTOW <BR> except where different we=
ights=20
are used for Domestic and <BR> international=
flights. =
&nb=
sp; =20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D924360720-24062003><FONT face=3DArial color=3D#0000ff si=
ze=3D2><FONT=20
face=3D"Courier New"> The billing system uses=
MCTOW=20
special instead of MCTOW <BR> in the=20
calculation of charges for International=20
flights.<BR> &nb=
sp; =
&nb=
sp; =
&nb=
sp;=20
<BR>  =
; &n=
bsp;  =
; &n=
bsp; =20
<BR> Values: &nbs=
p; =20
0 TO=20
99999999 &=
nbsp; &nbs=
p; =20
<BR>  =
; &n=
bsp;  =
; &n=
bsp; =20
<BR> Picture: &nb=
sp; =20
"=AC=AC,=AC=AC=AC,=AC=AC=AC" ( BWZ=20
) &n=
bsp; =20
<BR> Input Scale: 10 =AC=20
0 &n=
bsp;  =
; =20
<BR> Output Scale: 10 =AC=20
0 &n=
bsp;  =
; =20
<BR> Leading Sign: =20
"-" =
&nb=
sp; =
<BR> Significance: =20
1</FONT> &=
nbsp; &nbs=
p; &=
nbsp; =20
<BR>  =
; &n=
bsp;  =
; &n=
bsp; =20
<BR> Records: =20
AIRCRAFT &=
nbsp; &nbs=
p; &=
nbsp; =20
</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>
<P> </P></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft><FO=
NT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B> Grace, =
Jim=20
[mailto:Jim.Grace@ottawa.ccac-ont.ca] <BR><B>Sent:</B> Wednesday, 25 June=
2003=20
7:01 a.m.<BR><B>To:</B> 'powerh-l@lists.swau.edu'<BR><B>Subject:</B> Qsho=
w=20
Text Output<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi all, is there a way usin=
g Qshow=20
to output the Elements of the database to a text file, I'm sure I've done=
this=20
before but I don't see it in any Powerhouse manuals.</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in=20
advance</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">Jim</SPAN></FONT></P></DIV></BLOCKQUOTE><CODE><=
FONT SIZE=3D3><BR>
<BR>
**********************************************************************<BR>
This electronic message together with any attachments is confidential. If<B=
R>
you receive it in error: (i) you must not use, disclose, copy or retain<BR>
it; (ii) please contact the sender immediately by reply email and then<BR>
delete the emails. Views expressed in this email may not be those of the<BR>
Airways Corporation of New Zealand Limited<BR>
**********************************************************************<BR>
</FONT></CODE>
</BODY></HTML>
------_=_NextPart_001_01C33A8D.CEB40590--