<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Message</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:lime;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:lime;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>e.g.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>file mydefef in mydb primary occurs 7 access request rownum
&<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>unique using rownum<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>file fail_file in mydb secondary occurs with mydefef noitems open
read share <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>procedure find<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>begin<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>for mydefef<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>begin<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>if t_flag = "u"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> then begin<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> get mydefef &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> using rownum
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> let t_flag = "s"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> end <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> else get mydefef seq<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>get filea<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>get fileb<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>if not (row is related to customer B)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>then get fail_file using 'impossible string' via fail_file_col<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>end <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>end <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>fernando.olmos@hpa.com.au<br>
<b><span style='font-weight:bold'>Sent:</span></b> 21 August 2006 07:31<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> re: How to
"ignore" records in a FIND procedure</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Hi</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Yes I tried that...</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>The problem is that the get in the FIND
procedure ignores the fact that there are other tables that are REQUIRED for
the 1st table to even be considered for the cluster of records.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I think a subfile in QUICK is the only
solution...</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>FILE *MYSPECIFICDATA
PRIMARY OCCURS 15</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> atla38@dsl.pipex.com
[mailto:atla38@dsl.pipex.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, 21 August 2006 4:27
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Fernando Olmos;
powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: How to
"ignore" records in a FIND procedure</span></font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>Try something like this, you may have to
add occurs with occurs-file,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>File fail_row secondary noitems open read
……………………..( you will have to
create this and make sure no one adds any rows into it </span></font><font
color=lime face=Wingdings><span style='font-family:Wingdings;color:lime'>J</span></font><font
color=lime face=Arial><span style='font-family:Arial;color:lime'> )<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>In your find proc add syntax below, the
below probably has to go in the for loop after the fail-condition files have
all been read<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>If fail-conditions-are-true<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>then get fail_row<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'>A secondary without an optional will fail
the primary row when not accessok.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=lime face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:lime'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>fernando.olmos@hpa.com.au<br>
<b><span style='font-weight:bold'>Sent:</span></b> 21 August 2006 05:07<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: How to
"ignore" records in a FIND procedure</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>Just to add to this...</span></font> <o:p></o:p></p>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>The way I've been trying to do it, is to place an INTERNAL
call in the FIND procedure to count the number of detail records and determine
whether the total is based on the requirements I need. This way I was hoping to
pass back to the FIND procedure a counter or a flag to say to the GET... ignore
this get or do get the record for the cluster (based on the FOR MISSING
clause).</span></font><o:p></o:p></p>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>Thanks</span></font> <o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font><font
size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>-----Original
Message-----</span></font> <br>
<b><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma;
font-weight:bold'>From: </span></font></b> <font size=1 face=Tahoma><span
style='font-size:7.5pt;font-family:Tahoma'>Fernando Olmos </span></font><br>
<b><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma;
font-weight:bold'>Sent: </span></font></b> <font size=1 face=Tahoma><span
style='font-size:7.5pt;font-family:Tahoma'>Monday, 21 August 2006 2:04 PM</span></font>
<br>
<b><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma;
font-weight:bold'>To: </span></font></b> <font size=1
face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>powerh-l@lists.sowder.com</span></font>
<br>
<b><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma;
font-weight:bold'>Subject: </span></font></b>
<font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>How
to "ignore" records in a FIND procedure</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi
everyone.</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>How
is it possible, with logic, to be able to ignore the occurrence of a record
being retrieved into a cluster, within a FIND procedure?</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Obviously
the ACCESS and SELECT clauses at the FILE definition level is the quick answer,
but what if you require complex logic to determine, based on details records,
whether a record in a cluster should be included or not ?</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>i.e.
Here is the rows on my screen ...</span></font> <br>
<font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Account Number Name</span></font>
<br>
<font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>1234
Customer
A -- this customer has 20 detail records where
all records are not invoiced</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>
</span></font><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'>1235
Customer
B -- this customer has 10 detail records (orders)
where 9 of 10 are flagged as invoiced and the last rec is not invoiced</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>
</span></font><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'>1236
Customer
C -- this customer has 5 detail records where all
records are invoiced.</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
want to use some logic to only display CUSTOMER B in the cluster, on the
screen.</span></font> <o:p></o:p></p>
<p><i><font size=4 color=blue face=Arial><span style='font-size:13.5pt;
font-family:Arial;color:blue;font-style:italic'>Fernando Olmos</span></font></i>
<br>
<b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>MIS</span></font></b> <br>
<b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>Senior Analyst Programmer</span></font></b> <o:p></o:p></p>
<p><b><font size=2 color=blue face=Arial><span lang=EN-AU style='font-size:
10.0pt;font-family:Arial;color:blue;font-weight:bold'>HPA</span></font></b><font
face=Arial><span lang=EN-US style='font-family:Arial'><br>
</span></font><font size=2 color=black face=Arial><span lang=EN-AU
style='font-size:10.0pt;font-family:Arial;color:black'>Direct: 03 9217
5411</span></font><span lang=EN-US><br>
</span><st1:place w:st="on"><st1:City w:st="on"><font size=2 color=black
face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:Arial;
color:black'>Mobile</span></font></st1:City></st1:place><font size=2
color=black face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:
Arial;color:black'>: 0410 382 857</span></font><font face=Arial><span
lang=EN-US style='font-family:Arial'><br>
</span></font><font size=2 color=black face=Arial><span lang=EN-AU
style='font-size:10.0pt;font-family:Arial;color:black'>Fax:
03 9217 5716</span></font><span lang=EN-AU> </span><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><a
href="file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au"><b><font size=2
face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>www.hpa.com.au</span></font></b></a> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<pre><font size=2 face="Courier New"><span style='font-size:10.0pt'>**********************************************************************<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>IMPORTANT<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>The contents of this e-mail and its attachments are confidential and intended<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>solely for the use of the individual or entity to whom they are addressed. If<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>then delete the e-mail.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>This footnote also confirms that this e-mail message has been swept for the<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>presence of computer viruses by Ironport. Before opening or using any<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>attachments, check them for viruses and defects.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Our liability is limited to resupplying any affected attachments.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>HPA collects personal information to provide and market our services. For more<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>information about use, disclosure and access see our Privacy Policy at<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>www.hpa.com.au<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>**********************************************************************<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>**********************************************************************<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>IMPORTANT<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>The contents of this e-mail and its attachments are confidential and intended<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>solely for the use of the individual or entity to whom they are addressed. If<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>then delete the e-mail.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>This footnote also confirms that this e-mail message has been swept for the<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>presence of computer viruses by Ironport. Before opening or using any<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>attachments, check them for viruses and defects.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Our liability is limited to resupplying any affected attachments.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>HPA collects personal information to provide and market our services. For more<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>information about use, disclosure and access see our Privacy Policy at<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>www.hpa.com.au<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>**********************************************************************<o:p></o:p></span></font></pre></div>
</body>
</html>