LINKING TABLES
Kristina Carlton
Kristina.Carlton@JICompanies.com
Wed, 17 Nov 2004 09:29:49 -0600
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_01C4CCBA.48BD39A8
Content-Type: text/plain;
charset="iso-8859-1"
Can someone tell me how to index a field in a subfile? I cannot find the
syntax in the book we have.
Thanks,
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
512.427.2459
kristina.carlton@jicompanies.com
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]
Sent: Wednesday, November 17, 2004 5:58 AM
To: powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES
Indexed subfiles (on OpenVMS) were introduced in 7.10E1 if I recall
correctly. 7.10E did not have them. I seem to recall it was a case of trying
to meet a schedule (please be polite and don't hurt yourselves laughing) and
some features slipped. When we released E1, we included the indexed
subfiles. It would have been documented in a new features book or release
notes but probably not in the main manual.
Bob Deskin
Senior Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Martijn Nabben
(Fairfax)
Sent: November 16, 2004 10:25 PM
To: powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES
Yes it is,
We're using it all the time. It is a sincere undocumented feature; it became
official in the v8 series.
NB: In case of a physically kept indexed subfile, it MUST be in the same
directory as the program that uses it, or alternatively if your platform
allows logical names for physical directories/files, you can create a
logical name for the indexed subfile and then it doesn't matter anymore
where the file resides.
Vax/OpenVMS PH 7.10G
Cheers,
Martijn Nabben
Fairfax NZ
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Latimer, Richard
Sent: Wednesday, 17 November 2004 4:09
To: brian_matthewsbrian matthews; Kristina.Carlton@JICompanies.com;
powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES
Is 7.1 far enough up the PH food chain to be able to support indexed
subfiles and / or 'backwards' linking to them ??
Even if Kristina has an RDB behind her app the same problem may exist -
DB2/400 is an RDB but the PH version available for the iSeries doesn't
support any of the neat features like indexed subfiles and the ability to
control ordering in Quick that some of you lucky listers enjoy.
I suspect that the only real solution is to add a new index to her table.
regards
Richard
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of brian_matthewsbrian
matthews
Sent: Wednesday, 17 November 2004 3:49 p.m.
To: Kristina.Carlton@JICompanies.com; powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES
Assuming that your file is not a table in an RDB, and that the item
DOCUMENT_NUM of DTL is not an indexed segment there is another, but
potentially very slow option, and that is to use the linkage below.
ACC DTL LINK DOCUMENT_NUM TO DOCUMENT_NUM OF * DKF1:[DW]DWDTL
In order to do this you will need to make your subfile indexed on the item
DOCUMENT_NUM.
As long as you don't use optional on the access statement it will return
data only where a link was made to the subfile.
The other option is to make the item DOCUMENT_NUM of DTL an indexed segment
of the file and rebuild your file.
I am pretty sure that only applications which wish to use the new segment
need to be recompiled once the new index is added.
Bri,
>From: "Deskin, Bob" <Bob.Deskin@cognos.com>
>To: <powerh-l@lists.sowder.com>
>Subject: RE: LINKING TABLES Date: Tue, 16 Nov 2004 21:02:13 -0500
>
>That's correct. You can link to any column of a relational table by
>specifying the name of the column as a TO in the ACCESS. However, that
only
>applies to relational tables. To link to a non-relational indexed file
or
>IMAGE (on MPE/iX), you must link to a segment of a key or index. Bob
>Deskin Senior Product Manager, Application Development Tools
>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
>bob.deskin@cognos.com (613) 738-1338 ext 7268
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Jonbickel@aol.com
>Sent: November 16, 2004 4:57 PM
>To: powerh-l@lists.sowder.com
>Subject: Re: LINKING TABLES
>
>
>Kristina,
>
>By dictionary file, I assume that you mean an RMS file. IIRC, you
>cannot
>link on a non-indexed field to anything other than a relational table.
>
>jb
>
>In a message dated 11/16/2004 3:41:51 PM Central Standard Time,
>Kristina.Carlton@JICompanies.com writes:
>
>Hi List,
>
>I am using OpenVMS v7.3-2 and Quiz V7.10.G4.
>
>A while back I had trouble linking tables and got some help from this
>list.
>Everything has been working great, but today I ran into a problem
again. My
>attempt is to access a subfile, then link it to a dictionary file via
one
>field, which is not indexed.
>
>This is my access statement:
>
>ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL TO
>DOCUMENT_NUM
>OF DTL
>
>And the resulting error message:
>
>*E* Item(s) DOCUMENT_NUM not defined as an index of DTL.
>
>Can someone point out what I am doing wrong?
>
>
>
>Thanks,
>
>Kristina Carlton
>
>Senior Programmer/Analyst
>
>The JI Companies
>
>512.427.2459
>
>kristina.carlton@jicompanies.com
>
> This message may contain privileged and/or confidential
>information. If you have received this e-mail in error or are not the
>intended recipient, you may not use, copy, disseminate or distribute
it; do
>not open any attachments, delete it immediately from your system and
notify
>the sender promptly by e-mail that you have done so. Thank you.
>
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
--
**********************************************************************
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
**********************************************************************
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information.
If you have received this e-mail in error or are not the intended recipient,
you may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
------_=_NextPart_001_01C4CCBA.48BD39A8
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: LINKING TABLES</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Can someone tell me how to index a field in a =
subfile? I cannot find the syntax in the book we have.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Kristina Carlton</FONT>
<BR><FONT SIZE=3D2>Senior Programmer/Analyst</FONT>
<BR><FONT SIZE=3D2>The JI Companies</FONT>
<BR><FONT SIZE=3D2>512.427.2459</FONT>
<BR><FONT SIZE=3D2>kristina.carlton@jicompanies.com</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Deskin, Bob [<A =
HREF=3D"mailto:Bob.Deskin@cognos.com">mailto:Bob.Deskin@cognos.com</A>]<=
/FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, November 17, 2004 5:58 AM</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: LINKING TABLES</FONT>
</P>
<P><FONT SIZE=3D2>Indexed subfiles (on OpenVMS) were introduced in =
7.10E1 if I recall correctly. 7.10E did not have them. I seem to recall =
it was a case of trying to meet a schedule (please be polite and don't =
hurt yourselves laughing) and some features slipped. When we released =
E1, we included the indexed subfiles. It would have been documented in =
a new features book or release notes but probably not in the main =
manual.</FONT></P>
<P><FONT SIZE=3D2>Bob =
Deskin =
</FONT>
<BR><FONT SIZE=3D2>Senior Product Manager, Application Development =
Tools</FONT>
<BR><FONT SIZE=3D2>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 =
CANADA</FONT>
<BR><FONT SIZE=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: powerh-l-admin@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>]On Behalf Of Martijn Nabben</FONT>
<BR><FONT SIZE=3D2>(Fairfax)</FONT>
<BR><FONT SIZE=3D2>Sent: November 16, 2004 10:25 PM</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: LINKING TABLES</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Yes it is,</FONT>
</P>
<P><FONT SIZE=3D2>We're using it all the time. It is a sincere =
undocumented feature; it became</FONT>
<BR><FONT SIZE=3D2>official in the v8 series.</FONT>
</P>
<P><FONT SIZE=3D2>NB: In case of a physically kept indexed subfile, it =
MUST be in the same</FONT>
<BR><FONT SIZE=3D2>directory as the program that uses it, or =
alternatively if your platform</FONT>
<BR><FONT SIZE=3D2>allows logical names for physical directories/files, =
you can create a</FONT>
<BR><FONT SIZE=3D2>logical name for the indexed subfile and then it =
doesn't matter anymore</FONT>
<BR><FONT SIZE=3D2>where the file resides.</FONT>
</P>
<P><FONT SIZE=3D2>Vax/OpenVMS PH 7.10G</FONT>
</P>
<P><FONT SIZE=3D2>Cheers,</FONT>
<BR><FONT SIZE=3D2>Martijn Nabben</FONT>
<BR><FONT SIZE=3D2>Fairfax NZ</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: powerh-l-admin@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>] On Behalf Of Latimer, Richard</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, 17 November 2004 4:09</FONT>
<BR><FONT SIZE=3D2>To: brian_matthewsbrian matthews; =
Kristina.Carlton@JICompanies.com;</FONT>
<BR><FONT SIZE=3D2>powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: LINKING TABLES</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Is 7.1 far enough up the PH food chain to be able to =
support indexed</FONT>
<BR><FONT SIZE=3D2>subfiles and / or 'backwards' linking to them =
??</FONT>
</P>
<P><FONT SIZE=3D2>Even if Kristina has an RDB behind her app the same =
problem may exist -</FONT>
<BR><FONT SIZE=3D2>DB2/400 is an RDB but the PH version available for =
the iSeries doesn't</FONT>
<BR><FONT SIZE=3D2>support any of the neat features like indexed =
subfiles and the ability to</FONT>
<BR><FONT SIZE=3D2>control ordering in Quick that some of you lucky =
listers enjoy.</FONT>
</P>
<P><FONT SIZE=3D2>I suspect that the only real solution is to add a new =
index to her table.</FONT>
</P>
<P><FONT SIZE=3D2>regards</FONT>
<BR><FONT SIZE=3D2>Richard</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: powerh-l-admin@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>] On Behalf Of brian_matthewsbrian</FONT>
<BR><FONT SIZE=3D2>matthews</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, 17 November 2004 3:49 p.m.</FONT>
<BR><FONT SIZE=3D2>To: Kristina.Carlton@JICompanies.com; =
powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: LINKING TABLES</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Assuming that your file is not a table in an RDB, and =
that the item</FONT>
<BR><FONT SIZE=3D2>DOCUMENT_NUM of DTL is not an indexed segment there =
is another, but</FONT>
<BR><FONT SIZE=3D2>potentially very slow option, and that is to use the =
linkage below.</FONT>
</P>
<P><FONT SIZE=3D2>ACC DTL LINK DOCUMENT_NUM TO DOCUMENT_NUM OF * =
DKF1:[DW]DWDTL</FONT>
</P>
<P><FONT SIZE=3D2>In order to do this you will need to make your =
subfile indexed on the item</FONT>
<BR><FONT SIZE=3D2>DOCUMENT_NUM.</FONT>
</P>
<P><FONT SIZE=3D2>As long as you don't use optional on the access =
statement it will return</FONT>
</P>
<P><FONT SIZE=3D2>data only where a link was made to the =
subfile.</FONT>
</P>
<P><FONT SIZE=3D2>The other option is to make the item DOCUMENT_NUM of =
DTL an indexed segment</FONT>
<BR><FONT SIZE=3D2>of the file and rebuild your file.</FONT>
</P>
<P><FONT SIZE=3D2>I am pretty sure that only applications which wish to =
use the new segment</FONT>
<BR><FONT SIZE=3D2>need to be recompiled once the new index is =
added.</FONT>
</P>
<P><FONT SIZE=3D2>Bri,</FONT>
</P>
<P><FONT SIZE=3D2>>From: "Deskin, Bob" =
<Bob.Deskin@cognos.com></FONT>
<BR><FONT SIZE=3D2>>To: <powerh-l@lists.sowder.com></FONT>
<BR><FONT SIZE=3D2>>Subject: RE: LINKING TABLES Date: Tue, 16 Nov =
2004 21:02:13 -0500</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>That's correct. You can link to any column of a =
relational table by</FONT>
<BR><FONT SIZE=3D2>>specifying the name of the column as a TO in the =
ACCESS. However, that</FONT>
<BR><FONT SIZE=3D2>only</FONT>
<BR><FONT SIZE=3D2>>applies to relational tables. To link to a =
non-relational indexed file</FONT>
<BR><FONT SIZE=3D2>or</FONT>
<BR><FONT SIZE=3D2>>IMAGE (on MPE/iX), you must link to a segment of =
a key or index. Bob</FONT>
<BR><FONT SIZE=3D2>>Deskin Senior Product Manager, Application =
Development Tools</FONT>
<BR><FONT SIZE=3D2>>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G =
4K9 CANADA</FONT>
<BR><FONT SIZE=3D2>>bob.deskin@cognos.com (613) 738-1338 ext =
7268</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>>From: powerh-l-admin@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>>[<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>]On Behalf Of Jonbickel@aol.com</FONT>
<BR><FONT SIZE=3D2>>Sent: November 16, 2004 4:57 PM</FONT>
<BR><FONT SIZE=3D2>>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>>Subject: Re: LINKING TABLES</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Kristina,</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>By dictionary file, I assume that you mean an =
RMS file. IIRC, you</FONT>
<BR><FONT SIZE=3D2>>cannot</FONT>
<BR><FONT SIZE=3D2>>link on a non-indexed field to anything other =
than a relational table.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>jb</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>In a message dated 11/16/2004 3:41:51 PM Central =
Standard Time,</FONT>
<BR><FONT SIZE=3D2>>Kristina.Carlton@JICompanies.com writes:</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Hi List,</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>I am using OpenVMS v7.3-2 and Quiz =
V7.10.G4.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>A while back I had trouble linking tables and =
got some help from this</FONT>
<BR><FONT SIZE=3D2>>list.</FONT>
<BR><FONT SIZE=3D2>>Everything has been working great, but today I =
ran into a problem</FONT>
<BR><FONT SIZE=3D2>again. My</FONT>
<BR><FONT SIZE=3D2>>attempt is to access a subfile, then link it to =
a dictionary file via</FONT>
<BR><FONT SIZE=3D2>one</FONT>
<BR><FONT SIZE=3D2>>field, which is not indexed.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>This is my access statement:</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK =
DOCUMENT_NUM OF DWDTL TO</FONT>
<BR><FONT SIZE=3D2>>DOCUMENT_NUM</FONT>
<BR><FONT SIZE=3D2>>OF DTL</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>And the resulting error message:</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>*E* Item(s) DOCUMENT_NUM not defined as an index =
of DTL.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Can someone point out what I am doing =
wrong?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Thanks,</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Kristina Carlton</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Senior Programmer/Analyst</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>The JI Companies</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>512.427.2459</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>kristina.carlton@jicompanies.com</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> This =
message may contain privileged and/or confidential</FONT>
<BR><FONT SIZE=3D2>>information. If you have received this =
e-mail in error or are not the</FONT>
<BR><FONT SIZE=3D2>>intended recipient, you may not use, copy, =
disseminate or distribute</FONT>
<BR><FONT SIZE=3D2>it; do</FONT>
<BR><FONT SIZE=3D2>>not open any attachments, delete it immediately =
from your system and</FONT>
<BR><FONT SIZE=3D2>notify</FONT>
<BR><FONT SIZE=3D2>>the sender promptly by e-mail that you have done =
so. Thank you.</FONT>
<BR><FONT SIZE=3D2>></FONT>
</P>
<P><FONT =
SIZE=3D2>_______________________________________________________________=
__</FONT>
<BR><FONT SIZE=3D2>It's fast, it's easy and it's free. Get MSN =
Messenger today!</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.msn.co.uk/messenger" =
TARGET=3D"_blank">http://www.msn.co.uk/messenger</A></FONT>
</P>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to</FONT>
<BR><FONT SIZE=3D2>powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/FONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>--</FONT>
<BR><FONT =
SIZE=3D2>***************************************************************=
*******</FONT>
<BR><FONT SIZE=3D2>This electronic message together with any =
attachments is confidential. If</FONT>
<BR><FONT SIZE=3D2>you receive it in error: (i) you must not use, =
disclose, copy or retain it;</FONT>
<BR><FONT SIZE=3D2>(ii) please contact the sender immediately by reply =
email and then delete</FONT>
<BR><FONT SIZE=3D2>the emails. Views expressed in this email may not be =
those of the Airways</FONT>
<BR><FONT SIZE=3D2>Corporation of New Zealand Limited</FONT>
<BR><FONT =
SIZE=3D2>***************************************************************=
*******</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to</FONT>
<BR><FONT SIZE=3D2>powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/FONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
<BR><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/FONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> This message =
may contain privileged and/or confidential information. If you =
have received this e-mail in error or are not the intended recipient, =
you may not use, copy, disseminate or distribute it; do not open any =
attachments, delete it immediately from your system and notify the =
sender promptly by e-mail that you have done so. Thank =
you.</FONT></P>
<BR>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/FONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C4CCBA.48BD39A8--