LINKING TABLES

Wed, 17 Nov 2004 10:50:37 -0500

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4CCBD.2E9BF635
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

You can download the current documentation either from
support.cognos.com or from powerhouse.cognos.com. Get the QUIZ or QTP
manual and look up subfiles.
Bob Deskin             =20
Senior Product Manager, Application Development Tools, Cognos Inc.=20
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178=20
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA=20

	-----Original Message-----
	From: Kristina Carlton [mailto:Kristina.Carlton@JICompanies.com]

	Sent: November 17, 2004 10:30 AM
	To: Deskin, Bob; powerh-l@lists.sowder.com
	Subject: RE: LINKING TABLES
=09
=09

	Can someone tell me how to index a field in a subfile? I cannot
find the syntax in the book we have.=20

	Thanks,=20
	Kristina Carlton=20
	Senior Programmer/Analyst=20
	The JI Companies=20
	512.427.2459=20
	kristina.carlton@jicompanies.com=20

	-----Original Message-----=20
	From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]=20
	Sent: Wednesday, November 17, 2004 5:58 AM=20
	To: powerh-l@lists.sowder.com=20
	Subject: RE: LINKING TABLES=20

	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            =20
	Senior Product Manager, Application Development Tools=20
	Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA=20
	bob.deskin@cognos.com (613) 738-1338 ext 7268=20

	-----Original Message-----=20
	From: powerh-l-admin@lists.sowder.com=20
	[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Martijn
Nabben=20
	(Fairfax)=20
	Sent: November 16, 2004 10:25 PM=20
	To: powerh-l@lists.sowder.com=20
	Subject: RE: LINKING TABLES=20

	Yes it is,=20

	We're using it all the time. It is a sincere undocumented
feature; it became=20
	official in the v8 series.=20

	NB: In case of a physically kept indexed subfile, it MUST be in
the same=20
	directory as the program that uses it, or alternatively if your
platform=20
	allows logical names for physical directories/files, you can
create a=20
	logical name for the indexed subfile and then it doesn't matter
anymore=20
	where the file resides.=20

	Vax/OpenVMS PH 7.10G=20

	Cheers,=20
	Martijn Nabben=20
	Fairfax NZ=20

	-----Original Message-----=20
	From: powerh-l-admin@lists.sowder.com=20
	[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Latimer,
Richard=20
	Sent: Wednesday, 17 November 2004 4:09=20
	To: brian_matthewsbrian matthews;
Kristina.Carlton@JICompanies.com;=20
	powerh-l@lists.sowder.com=20
	Subject: RE: LINKING TABLES=20

	Is 7.1 far enough up the PH food chain to be able to support
indexed=20
	subfiles and / or 'backwards' linking to them ??=20

	Even if Kristina has an RDB behind her app the same problem may
exist -=20
	DB2/400 is an RDB but the PH version available for the iSeries
doesn't=20
	support any of the neat features like indexed subfiles and the
ability to=20
	control ordering in Quick that some of you lucky listers enjoy.=20

	I suspect that the only real solution is to add a new index to
her table.=20

	regards=20
	Richard=20

	-----Original Message-----=20
	From: powerh-l-admin@lists.sowder.com=20
	[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
brian_matthewsbrian=20
	matthews=20
	Sent: Wednesday, 17 November 2004 3:49 p.m.=20
	To: Kristina.Carlton@JICompanies.com; powerh-l@lists.sowder.com=20
	Subject: RE: LINKING TABLES=20

	Assuming that your file is not a table in an RDB, and that the
item=20
	DOCUMENT_NUM of DTL is not an indexed segment there is another,
but=20
	potentially very slow option, and that is to use the linkage
below.=20

	ACC  DTL LINK DOCUMENT_NUM TO DOCUMENT_NUM OF * DKF1:[DW]DWDTL=20

	In order to do this you will need to make your subfile indexed
on the item=20
	DOCUMENT_NUM.=20

	As long as you don't use optional on the access statement it
will return=20

	data only where a link was made to the subfile.=20

	The other option is to make the item DOCUMENT_NUM of DTL an
indexed segment=20
	of the file and rebuild your file.=20

	I am pretty sure that only applications which wish to use the
new segment=20
	need to be recompiled once the new index is added.=20

	Bri,=20

	>From: "Deskin, Bob" <Bob.Deskin@cognos.com>=20
	>To: <powerh-l@lists.sowder.com>=20
	>Subject: RE: LINKING TABLES Date: Tue, 16 Nov 2004 21:02:13
-0500=20
	>=20
	>That's correct. You can link to any column of a relational
table by=20
	>specifying the name of the column as a TO in the ACCESS.
However, that=20
	only=20
	>applies to relational tables. To link to a non-relational
indexed file=20
	or=20
	>IMAGE (on MPE/iX), you must link to a segment of a key or
index. Bob=20
	>Deskin Senior Product Manager, Application Development Tools=20
	>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA=20
	>bob.deskin@cognos.com (613) 738-1338 ext 7268=20
	>=20
	>-----Original Message-----=20
	>From: powerh-l-admin@lists.sowder.com=20
	>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of
Jonbickel@aol.com=20
	>Sent: November 16, 2004 4:57 PM=20
	>To: powerh-l@lists.sowder.com=20
	>Subject: Re: LINKING TABLES=20
	>=20
	>=20
	>Kristina,=20
	>=20
	>By dictionary file, I assume that you mean an RMS file.  IIRC,
you=20
	>cannot=20
	>link on a non-indexed field to anything other than a relational
table.=20
	>=20
	>jb=20
	>=20
	>In a message dated 11/16/2004 3:41:51 PM Central Standard Time,

	>Kristina.Carlton@JICompanies.com writes:=20
	>=20
	>Hi List,=20
	>=20
	>I am using OpenVMS v7.3-2 and Quiz V7.10.G4.=20
	>=20
	>A while back I had trouble linking tables and got some help
from this=20
	>list.=20
	>Everything has been working great, but today I ran into a
problem=20
	again. My=20
	>attempt is to access a subfile, then link it to a dictionary
file via=20
	one=20
	>field, which is not indexed.=20
	>=20
	>This is my access statement:=20
	>=20
	>ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL  TO=20
	>DOCUMENT_NUM=20
	>OF DTL=20
	>=20
	>And the resulting error message:=20
	>=20
	>*E* Item(s) DOCUMENT_NUM not defined as an index of DTL.=20
	>=20
	>Can someone point out what I am doing wrong?=20
	>=20
	>=20
	>=20
	>Thanks,=20
	>=20
	>Kristina Carlton=20
	>=20
	>Senior Programmer/Analyst=20
	>=20
	>The JI Companies=20
	>=20
	>512.427.2459=20
	>=20
	>kristina.carlton@jicompanies.com=20
	>=20
	>        This message may contain privileged and/or confidential

	>information.  If you have received this e-mail in error or are
not the=20
	>intended recipient, you may not use, copy, disseminate or
distribute=20
	it; do=20
	>not open any attachments, delete it immediately from your
system and=20
	notify=20
	>the sender promptly by e-mail that you have done so.  Thank
you.=20
	>=20

=09
_________________________________________________________________=20
	It's fast, it's easy and it's free. Get MSN Messenger today!=20
	http://www.msn.co.uk/messenger=20

	=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=20
	Mailing list: powerh-l@lists.sowder.com=20
	Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com=20
	Unsubscribe: "unsubscribe <password>" in message body to=20
	powerh-l-request@lists.sowder.com=20
	http://lists.sowder.com/mailman/listinfo/powerh-l=20
	This list is closed, thus to post to the list you must be a
subscriber.=20

	--=20
=09
**********************************************************************=20
	This electronic message together with any attachments is
confidential. If=20
	you receive it in error: (i) you must not use, disclose, copy or
retain it;=20
	(ii) please contact the sender immediately by reply email and
then delete=20
	the emails. Views expressed in this email may not be those of
the Airways=20
	Corporation of New Zealand Limited=20
=09
**********************************************************************=20

	=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=20
	Mailing list: powerh-l@lists.sowder.com=20
	Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com=20
	Unsubscribe: "unsubscribe <password>" in message body to=20
	powerh-l-request@lists.sowder.com=20
	http://lists.sowder.com/mailman/listinfo/powerh-l=20
	This list is closed, thus to post to the list you must be a
subscriber.=20
	=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=20
	Mailing list: powerh-l@lists.sowder.com=20
	Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com=20
	Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com=20
	http://lists.sowder.com/mailman/listinfo/powerh-l=20
	This list is closed, thus to post to the list you must be a
subscriber.=20
	 =20
	       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.

	=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=20
	Mailing list: powerh-l@lists.sowder.com=20
	Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com=20
	Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com=20
	http://lists.sowder.com/mailman/listinfo/powerh-l=20
	This list is closed, thus to post to the list you must be a
subscriber.=20

------_=_NextPart_001_01C4CCBD.2E9BF635
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD>
<BODY>
<DIV>You=20
can download the current documentation either from support.cognos.com or =
from=20
powerhouse.cognos.com. Get the QUIZ or QTP manual and look up=20
subfiles.</DIV>
<DIV>
Bob=20
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;=20
 Senior =
Product=20
Manager, Application Development Tools, Cognos Inc. =
 <SPAN=20
lang=3Den-us>bob.deskin@cognos.com (613) =
738-1338 ext 7268=20
FAX: (613) 727-1178 3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9=20
CANADA </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
 <DIV></DIV>
 <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
 face=3DTahoma size=3D2>-----Original Message----- From: =
Kristina Carlton=20
 [mailto:Kristina.Carlton@JICompanies.com] Sent: November =
17, 2004=20
 10:30 AM To: Deskin, Bob;=20
 powerh-l@lists.sowder.com Subject: RE: LINKING=20
 TABLES </DIV>
 Can someone tell me how to index a field in a =
subfile? I=20
 cannot find the syntax in the book we have. 
 Thanks, Kristina =
Carlton=20
 Senior Programmer/Analyst The JI=20
 Companies 512.427.2459 <FONT=20
 size=3D2>kristina.carlton@jicompanies.com 
 -----Original Message----- From:=20
 Deskin, Bob [<A=20
 =
href=3D"mailto:Bob.Deskin@cognos.com">mailto:Bob.Deskin@cognos.com</A>]</=
FONT>=20
 Sent: Wednesday, November 17, 2004 5:58 AM =
 <FONT=20
 size=3D2>To: powerh-l@lists.sowder.com Subject: RE:=20
 LINKING TABLES 
 Indexed subfiles (on OpenVMS) were introduced in =
7.10E1 if I=20
 recall correctly. 7.10E did not have them. I seem to recall it was a =
case of=20
 trying to meet a schedule (please be polite and don't hurt yourselves=20
 laughing) and some features slipped. When we released E1, we included =
the=20
 indexed subfiles. It would have been documented in a new features book =
or=20
 release notes but probably not in the main manual.
 Bob=20
 =
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;=20
 Senior Product Manager, Application =
Development=20
 Tools Cognos Inc. 3755 Riverside Drive, =
Ottawa ON K1G=20
 4K9 CANADA bob.deskin@cognos.com (613) =
738-1338 ext=20
 7268 
 -----Original Message----- From:=20
 powerh-l-admin@lists.sowder.com [<A=20
 =
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</A>]On=20
 Behalf Of Martijn Nabben (Fairfax) =
 <FONT=20
 size=3D2>Sent: November 16, 2004 10:25 PM To:=20
 powerh-l@lists.sowder.com Subject: RE: =
LINKING=20
 TABLES 
 Yes it is, 
 We're using it all the time. It is a sincere =
undocumented=20
 feature; it became official in the v8 =
series.=20
 
 NB: In case of a physically kept indexed subfile, it =
MUST be=20
 in the same directory as the program that =
uses it, or=20
 alternatively if your platform allows =
logical names=20
 for physical directories/files, you can create a <FONT=20
 size=3D2>logical name for the indexed subfile and then it doesn't =
matter=20
 anymore where the file resides. 
 Vax/OpenVMS PH 7.10G 
 Cheers, Martijn =
Nabben=20
 Fairfax NZ 
 -----Original Message----- From:=20
 powerh-l-admin@lists.sowder.com [<A=20
 =
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</A>]=20
 On Behalf Of Latimer, Richard Sent: =
Wednesday, 17=20
 November 2004 4:09 To: brian_matthewsbrian =
matthews;=20
 Kristina.Carlton@JICompanies.com; <FONT=20
 size=3D2>powerh-l@lists.sowder.com Subject: =
RE: LINKING=20
 TABLES 
 Is 7.1 far enough up the PH food chain to be able to =
support=20
 indexed subfiles and / or 'backwards' =
linking to them=20
 ?? 
 Even if Kristina has an RDB behind her app the same =
problem=20
 may exist - DB2/400 is an RDB but the PH =
version=20
 available for the iSeries doesn't support =
any of the=20
 neat features like indexed subfiles and the ability to =
 <FONT=20
 size=3D2>control ordering in Quick that some of you lucky listers =
enjoy.=20
 
 I suspect that the only real solution is to add a =
new index to=20
 her table. 
 regards Richard =
 
 -----Original Message----- From:=20
 powerh-l-admin@lists.sowder.com [<A=20
 =
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</A>]=20
 On Behalf Of brian_matthewsbrian matthews=20
 Sent: Wednesday, 17 November 2004 3:49 p.m. =
 <FONT=20
 size=3D2>To: Kristina.Carlton@JICompanies.com; =
powerh-l@lists.sowder.com=20
 Subject: RE: LINKING TABLES 
 Assuming that your file is not a table in an RDB, =
and that the=20
 item DOCUMENT_NUM of DTL is not an indexed =
segment=20
 there is another, but potentially very slow =
option,=20
 and that is to use the linkage below. 
 ACC&nbsp; 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=20
  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=20
  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=20
  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=20
  new segment</FONT> <BR><FONT size=3D2>need to be recompiled once the =
new index=20
  is added.</FONT> </P>
  <P><FONT size=3D2>Bri,</FONT> </P>
  <P><FONT size=3D2>&gt;From: "Deskin, Bob" =
&lt;Bob.Deskin@cognos.com&gt;</FONT>=20
  <BR><FONT size=3D2>&gt;To: &lt;powerh-l@lists.sowder.com&gt;</FONT> =
<BR><FONT=20
  size=3D2>&gt;Subject: RE: LINKING TABLES Date: Tue, 16 Nov 2004 =
21:02:13=20
  -0500</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT =
size=3D2>&gt;That's correct.=20
  You can link to any column of a relational table by</FONT> <BR><FONT=20
  size=3D2>&gt;specifying the name of the column as a TO in the ACCESS. =
However,=20
  that</FONT> <BR><FONT size=3D2>only</FONT> <BR><FONT =
size=3D2>&gt;applies to=20
  relational tables. To link to a non-relational indexed file</FONT> =
<BR><FONT=20
  size=3D2>or</FONT> <BR><FONT size=3D2>&gt;IMAGE (on MPE/iX), you must =
link to a=20
  segment of a key or index. Bob</FONT> <BR><FONT size=3D2>&gt;Deskin =
Senior=20
  Product Manager, Application Development Tools</FONT> <BR><FONT=20
  size=3D2>&gt;Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 =
CANADA</FONT>=20
  <BR><FONT size=3D2>&gt;bob.deskin@cognos.com (613) 738-1338 ext =
7268</FONT>=20
  <BR><FONT size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;-----Original=20
  Message-----</FONT> <BR><FONT size=3D2>&gt;From:=20
  powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=3D2>&gt;[<A=20
  =
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</A>]On=20
  Behalf Of Jonbickel@aol.com</FONT> <BR><FONT size=3D2>&gt;Sent: =
November 16,=20
  2004 4:57 PM</FONT> <BR><FONT size=3D2>&gt;To: =
powerh-l@lists.sowder.com</FONT>=20
  <BR><FONT size=3D2>&gt;Subject: Re: LINKING TABLES</FONT> <BR><FONT=20
  size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT=20
  size=3D2>&gt;Kristina,</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT =

  size=3D2>&gt;By dictionary file, I assume that you mean an RMS =
file.&nbsp; IIRC,=20
  you</FONT> <BR><FONT size=3D2>&gt;cannot</FONT> <BR><FONT =
size=3D2>&gt;link on a=20
  non-indexed field to anything other than a relational table.</FONT> =
<BR><FONT=20
  size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;jb</FONT> <BR><FONT =
size=3D2>&gt;</FONT>=20
  <BR><FONT size=3D2>&gt;In a message dated 11/16/2004 3:41:51 PM =
Central Standard=20
  Time,</FONT> <BR><FONT size=3D2>&gt;Kristina.Carlton@JICompanies.com=20
  writes:</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT =
size=3D2>&gt;Hi=20
  List,</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;I =
am using=20
  OpenVMS v7.3-2 and Quiz V7.10.G4.</FONT> <BR><FONT =
size=3D2>&gt;</FONT>=20
  <BR><FONT size=3D2>&gt;A while back I had trouble linking tables and =
got some=20
  help from this</FONT> <BR><FONT size=3D2>&gt;list.</FONT> <BR><FONT=20
  size=3D2>&gt;Everything has been working great, but today I ran into a =

problem again. My &gt;attempt=20
 is to access a subfile, then link it to a dictionary file via =
 <FONT=20
 size=3D2>one &gt;field, which is not =
indexed.=20
 &gt; &gt;This is my =
access=20
 statement: &gt; &gt;ACC=20
 *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL&nbsp; TO =

  <BR><FONT size=3D2>&gt;DOCUMENT_NUM</FONT> <BR><FONT size=3D2>&gt;OF =
DTL</FONT>=20
  <BR><FONT size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;And the =
resulting error=20
  message:</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT =
size=3D2>&gt;*E* Item(s)=20
  DOCUMENT_NUM not defined as an index of DTL.</FONT> <BR><FONT=20
  size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;Can someone point out what =
I am doing=20
  wrong?</FONT> <BR><FONT size=3D2>&gt;</FONT> <BR><FONT =
size=3D2>&gt;</FONT>=20
  <BR><FONT size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;Thanks,</FONT> =
<BR><FONT=20
  size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;Kristina Carlton</FONT> =
<BR><FONT=20
  size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;Senior =
Programmer/Analyst</FONT>=20
  <BR><FONT size=3D2>&gt;</FONT> <BR><FONT size=3D2>&gt;The JI =
Companies</FONT>=20
  <BR><FONT size=3D2>&gt;</FONT> <BR><FONT =
size=3D2>&gt;512.427.2459</FONT>=20
  <BR><FONT size=3D2>&gt;</FONT> <BR><FONT=20
  size=3D2>&gt;kristina.carlton@jicompanies.com</FONT> <BR><FONT=20
  size=3D2>&gt;</FONT> <BR><FONT=20
  size=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This message =
may contain=20
  privileged and/or confidential</FONT> <BR><FONT =
size=3D2>&gt;information.&nbsp;=20
  If you have received this e-mail in error or are not the</FONT> =
<BR><FONT=20
  size=3D2>&gt;intended recipient, you may not use, copy, disseminate or =

  distribute</FONT> <BR><FONT size=3D2>it; do</FONT> <BR><FONT =
size=3D2>&gt;not open=20
  any attachments, delete it immediately from your system and</FONT> =
<BR><FONT=20
  size=3D2>notify</FONT> <BR><FONT size=3D2>&gt;the sender promptly by =
e-mail that=20
  you have done so.&nbsp; Thank you.</FONT> <BR><FONT =
size=3D2>&gt;</FONT> </P>
  <P><FONT=20
  =
size=3D2>________________________________________________________________=
_</FONT>=20
  <BR><FONT size=3D2>It's fast, it's easy and it's free. Get MSN =
Messenger=20
  today!</FONT> <BR><FONT size=3D2><A =
href=3D"http://www.msn.co.uk/messenger"=20
  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>=20
  <BR><FONT size=3D2>Mailing list: powerh-l@lists.sowder.com</FONT> =
<BR><FONT=20
  size=3D2>Subscribe: "subscribe" in message body to=20
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
  "unsubscribe &lt;password&gt;" in message body to</FONT> <BR><FONT=20
  size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2><A=20
  href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
  =
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FO=
NT>=20
  <BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
  subscriber.</FONT> </P><BR>
  <P><FONT size=3D2>--</FONT> <BR><FONT=20
  =
size=3D2>****************************************************************=
******</FONT>=20
  <BR><FONT size=3D2>This electronic message together with any =
attachments is=20
  confidential. If</FONT> <BR><FONT size=3D2>you receive it in error: =
(i) you must=20
  not use, disclose, copy or retain it;</FONT> <BR><FONT size=3D2>(ii) =
please=20
  contact the sender immediately by reply email and then delete</FONT> =
<BR><FONT=20
  size=3D2>the emails. Views expressed in this email may not be those of =
the=20
  Airways</FONT> <BR><FONT size=3D2>Corporation of New Zealand =
Limited</FONT>=20
  <BR><FONT=20
  =
size=3D2>****************************************************************=
******</FONT>=20
  </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>=20
  <BR><FONT size=3D2>Mailing list: powerh-l@lists.sowder.com</FONT> =
<BR><FONT=20
  size=3D2>Subscribe: "subscribe" in message body to=20
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
  "unsubscribe &lt;password&gt;" in message body to</FONT> <BR><FONT=20
  size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2><A=20
  href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
  =
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FO=
NT>=20
  <BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
  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=20
  =3D =3D =3D =3D =3D =3D =3D</FONT> <BR><FONT size=3D2>Mailing list:=20
  powerh-l@lists.sowder.com</FONT> <BR><FONT size=3D2>Subscribe: =
"subscribe" in=20
  message body to powerh-l-request@lists.sowder.com</FONT> <BR><FONT=20
  size=3D2>Unsubscribe: "unsubscribe &lt;password&gt;" in message body =
to=20
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=3D2><A=20
  href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
  =
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FO=
NT>=20
  <BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
  subscriber.</FONT> <BR><FONT size=3D2>&nbsp;</FONT> <BR><FONT=20
  size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This message may contain =

  privileged and/or confidential information.&nbsp; If you have received =
this=20
  e-mail in error or are not the intended recipient, you may not use, =
copy,=20
  disseminate or distribute it; do not open any attachments, delete it=20
  immediately from your system and notify the sender promptly by e-mail =
that you=20
  have done so.&nbsp; 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>=20
  <BR><FONT size=3D2>Mailing list: powerh-l@lists.sowder.com</FONT> =
<BR><FONT=20
  size=3D2>Subscribe: "subscribe" in message body to=20
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
  "unsubscribe &lt;password&gt;" in message body to=20
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=3D2><A=20
  href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
  =
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FO=
NT>=20
  <BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
  subscriber.</FONT> </P></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C4CCBD.2E9BF635--