Sorting rows in a cluster
Harvey Orom
harvey@oromconsulting.com
Wed, 20 Oct 2004 12:27:27 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0030_01C4B6A0.29399A40
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi Joe,
I appreciate all the thought you have put into this, but I believe there is
a "chicken and egg" problem with the solution. I can't retrieve records from
the reference file without first retrieving records from the primary file.
( I probably didn't make that clear originally) So when I try to make the
driver file the old reference file, I have no way to retrieve the records
from this file. Or am I missing something?
Cheers ... Harvey
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Joe Boyle
Sent: Wednesday, October 20, 2004 12:03 PM
To: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
My final word on this topic ( I promise ).
I am suggesting that the current reference file be mapped in a second file
statement, but this time as the primary with the orderby syntax as below,
File orig-refnce alias new-primry primary occurs 15
Access orderby column using .via. request.etc.
File orig-prmry alias new-seconry secondary
Access via .using columns of new-primry etc.
File orig-refnce reference
Access etc.
Regards, Joe.
This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.
----------------------------------------------------------------------------
--
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Harvey Orom
Sent: 20 October 2004 19:13
To: Whittall, Conrad; powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
That sounds like a winner. I will give it a try. Thanks!
Cheers ... Harvey
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Whittall, Conrad
Sent: Wednesday, October 20, 2004 10:28 AM
To: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
You could use a database view as a non-updateable Primary, and then
retrieve the underlying row from the 'real' table as a Secondary (access via
the primary key included in the view) and allow the user to interact with
the fields from the secondary records...so retaining the default PowerHouse
processing and eliminating the need for procedural loops, etc.
I have used this technique quite a few times with great success.
Best regards,
Conrad
Conrad Whittall
Senior Solutions Architect, Global Customer Services, Cognos
Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
----------------------------------------------------------------------------
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Harvey Orom
Sent: Wednesday 20 October 2004 11:46
To: Rohde, Dirk
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
True, but since I want to update the primary file within the cluster, I
think I will lose the convenience and elegance of standard PowerHouse
procedures. I would need to use temp fields in the cluster, and create a
loop to write the file as a designer file.
RDB allows updateable views only if one table is involved.
Cheers ... Harvey
-----Original Message-----
From: Rohde, Dirk [mailto:Dirk.Rohde@vpgroup.com]
Sent: Wednesday, October 20, 2004 8:28 AM
To: 'Harvey Orom'
Subject: RE: Sorting rows in a cluster
Does RDB not allow you to define a view? If you define a view linking
your primary and reference files, you should then be able to access it as
your primary and sort on the reference field.
-----Original Message-----
From: Harvey Orom [mailto:harvey@oromconsulting.com]
Sent: Wednesday, October 20, 2004 8:13 AM
To: Joe Boyle
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
My environment is vms, rdb, and PowerHouse 7.10.G1. That release of
PowerHouse doesn't appear to recognize any of the cursor keywords, so maybe
the cursor idea is academic, given my environment. I can create cursors in
Rdb, but I am not sure if that will do me much good.
Cheers ... Harvey
Harvey Orom
Orom Consulting Ltd.
2765 Tudor Ave.
Victoria, BC
Canada, V8N 1L6
Phone: (250) 477-8332
Email: harvey@oromconsulting.com
www.oromconsulting.com
-----Original Message-----
From: Joe Boyle [mailto:joeboyle_adt@hotmail.com]
Sent: Wednesday, October 20, 2004 7:27 AM
To: 'Harvey Orom'
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
At the risk of stating the obvious, you can only use cursors with
relational databases.
Which file system are you using and which PH version and platform
?
Regards, Joe.
This e-mail and all information contained in it is confidential
and may be legally privileged. If you are not the intended recipient, your
access to this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.
----------------------------------------------------------------------
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Harvey Orom
Sent: 20 October 2004 00:06
To: Bickel, Jon
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
Unfortunately, I get the reference file from the primary file. I
know I could use a view, with temp fields in the cluster, and a loop to put
a designer file. I am just trolling for a more elegant solution. Someone
suggested a cursor - what do you think of that?
Cheers ... Harvey
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Bickel, Jon
Sent: Tuesday, October 19, 2004 3:21 PM
To: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
Harvey,
Is it possible to get the reference file first and then retrieve
the primary, or is the retrieval of the reference file based on a value from
the primary?
jb
-----Original Message-----
From: Harvey Orom [mailto:harvey@oromconsulting.com]
Sent: Tuesday, October 19, 2004 5:01 PM
To: powerh-l@lists.sowder.com
Subject: Sorting rows in a cluster
Is there any way to present the rows in a cluster in a
PowerHouse Quick screen in a sequence by a column that is not in the primary
file (I.e., the column I want to sort by comes from a reference file.) The
primary file is being updated in this screen.
Thanks in advance...
Harvey Orom
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.
------=_NextPart_000_0030_01C4B6A0.29399A40
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags" xmlns:ns1 =3D=20
"http://www.exclaimer.co.uk"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR><!--[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]--><o:SmartTagType name=3D"PostalCode"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"country-region"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"State"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"address"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"Street"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Arial Black;
}
@font-face {
font-family: Verdana;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 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
}
P.MsoPlainText {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"
}
LI.MsoPlainText {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"
}
DIV.MsoPlainText {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: =
"Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
<O:SMARTTAGTYPE name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></O:SMARTTAGT=
YPE><O:SMARTTAGTYPE=20
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></O:SMARTTAGT=
YPE></HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D861331819-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Hi=20
Joe,</FONT></SPAN></DIV>
<DIV><SPAN class=3D861331819-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D861331819-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
appreciate all the thought you have put into this, but I believe there =
is a=20
"chicken and egg" problem with the solution. I can't retrieve records =
from the=20
reference file without first retrieving records from the primary file. ( =
I=20
probably didn't make that clear originally) So when I try to make =
the=20
driver file the old reference file, I have no way to retrieve the =
records=20
from this file. Or am I missing something?</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D861331819-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Cheers=20
... Harvey</FONT></SPAN></DIV>
<P><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Joe Boyle<BR><B>Sent:</B> Wednesday, October 20, 2004 =
12:03=20
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: =
Sorting rows=20
in a cluster<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">My final =
word on this=20
topic ( I promise ).<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I am =
suggesting that=20
the current reference file be mapped in a second file statement, but =
this time=20
as the primary with the orderby syntax as below, =
<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">File=20
orig-refnce alias new-primry primary occurs =
15<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Access=20
orderby column using …via… =
request…etc…<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">File=20
orig-prmry alias new-seconry secondary<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Access=20
via …using columns of new-primry =
etc…<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">File=20
orig-refnce reference<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DArial =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Access=20
etc…<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,=20
Joe.</SPAN></FONT><FONT color=3Dnavy><SPAN=20
style=3D"COLOR: navy"><o:p></o:p></SPAN></FONT></P>
<P><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">This e-mail =
and all=20
information contained in it is confidential and may be legally =
privileged. If=20
you are not the intended</SPAN></FONT><FONT color=3Dnavy><SPAN=20
style=3D"COLOR: navy"> </SPAN></FONT><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">recipient, =
your=20
access to this e-mail is unauthorized. Any use, dissemination, =
distribution,=20
publication or copying by you of this e-mail or any of the information =
contained within it is prohibited and may be unlawful. Do not open any =
attachments, delete it immediately from your system and notify the =
sender=20
promptly by e-mail that you have done so. The content of this e-mail =
and any=20
attachments sent with it may have been altered without the consent or=20
knowledge of the author.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><FONT=20
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D3>
</SPAN></FONT></DIV>
<P class=3DMsoNormal><B><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]=20
<B><SPAN style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Harvey=20
Orom<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> 20 =
October 2004=20
19:13<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Whittall, =
Conrad;=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting rows in a=20
cluster</SPAN></FONT><o:p></o:p></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">That sounds =
like a=20
winner. I will give it a try. =
Thanks!</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Cheers ... =
<st1:City=20
w:st=3D"on"><st1:place=20
=
w:st=3D"on">Harvey</st1:place></st1:City></SPAN></FONT><o:p></o:p></P></D=
IV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<BLOCKQUOTE style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; =
MARGIN-RIGHT: 0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com]<B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Whittall,=20
Conrad<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
Wednesday,=20
October 20, 2004 10:28 AM<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting rows in =
a=20
cluster</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DVerdana size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">You could use a =
database view=20
as a non-updateable Primary, and then retrieve the underlying row =
from the=20
'real' table as a Secondary (access via the primary key included in =
the=20
view) and allow the user to interact with the fields from the =
secondary=20
records...so retaining the default PowerHouse processing and =
eliminating the=20
need for procedural loops, etc.</SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DVerdana size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">I have used this =
technique=20
quite a few times with great success.</SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DVerdana size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Best=20
regards,<BR></SPAN></FONT><B><I><FONT color=3Dnavy size=3D6><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 24pt; COLOR: navy; =
FONT-STYLE: italic">Conrad</SPAN></FONT></I></B><FONT=20
face=3DVerdana size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Verdana">=20
<o:p></o:p></SPAN></FONT></P>
<P><FONT face=3DVerdana color=3Dgray size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">Conrad =
Whittall</SPAN></FONT><BR><FONT face=3DVerdana color=3Dgray =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">Senior =
Solutions=20
Architect, Global Customer Services, Cognos=20
Incorporated</SPAN></FONT><BR><st1:place w:st=3D"on"><FONT =
face=3DVerdana=20
color=3Dgray size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">3755 =
Riverside=20
Drive, <st1:City w:st=3D"on">Ottawa</st1:City>, <st1:State=20
w:st=3D"on">Ontario</st1:State>, <st1:PostalCode w:st=3D"on">K1G=20
4K9</st1:PostalCode>, <st1:country-region=20
=
w:st=3D"on">Canada</st1:country-region></SPAN></FONT></st1:place><o:p></o=
:p></P>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><FONT=20
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D3>
</SPAN></FONT></DIV>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><B><FONT =
face=3DTahoma=20
size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]=20
<B><SPAN style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Harvey=20
Orom<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
Wednesday 20=20
October 2004 11:46<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">To:</SPAN></B>=20
Rohde, Dirk<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Cc:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting rows in =
a=20
cluster</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">True, but =
since I=20
want to update the primary file within the cluster, I think I will =
lose the=20
convenience and elegance of standard PowerHouse procedures. I =
would=20
need to use temp fields in the cluster, and create a loop to write =
the file=20
as a designer file. </SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">RDB =
allows=20
updateable views only if one table is involved.=20
</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Cheers =
...=20
<st1:City w:st=3D"on"><st1:place=20
=
w:st=3D"on">Harvey</st1:place></st1:City></SPAN></FONT><o:p></o:p></P></D=
IV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm"><P=20
class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B> Rohde,=20
Dirk [mailto:Dirk.Rohde@vpgroup.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, October =
20, 2004=20
8:28 AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> =
'Harvey=20
Orom'<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> =
RE:=20
Sorting rows in a cluster</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Does =
RDB not=20
allow you to define a view? If you define a view linking your =
primary and=20
reference files, you should then be able to access it as your =
primary and=20
sort on the reference field.</SPAN></FONT><o:p></o:p></P></DIV>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
Harvey Orom [mailto:harvey@oromconsulting.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, October =
20, 2004=20
8:13 AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> =
Joe=20
Boyle<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Cc:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting rows =
in a=20
cluster</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">My =
environment=20
is vms, rdb, and PowerHouse 7.10.G1. That release of PowerHouse =
doesn't=20
appear to recognize any of the cursor keywords, so maybe the =
cursor idea=20
is academic, given my environment. I can create cursors in Rdb, =
but=20
I am not sure if that will do me much=20
good.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Cheers ...=20
<st1:City w:st=3D"on"><st1:place=20
=
w:st=3D"on">Harvey</st1:place></st1:City></SPAN></FONT><o:p></o:p></P></D=
IV>
<P><FONT face=3D"Arial Black" color=3Dnavy size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: 'Arial =
Black'">Harvey=20
Orom</SPAN></FONT> <BR><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Orom Consulting=20
Ltd.</SPAN></FONT> <BR><st1:Street w:st=3D"on"><st1:address=20
w:st=3D"on"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">2765 Tudor=20
Ave.</SPAN></FONT></st1:address></st1:Street> <BR><st1:place=20
w:st=3D"on"><st1:City w:st=3D"on"><FONT face=3DArial =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Victoria</SPAN></FONT></st1:City><FONT=20
face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
FONT-FAMILY: Arial">,=20
<st1:State w:st=3D"on">BC</st1:State></SPAN></FONT>=20
<BR><st1:country-region w:st=3D"on"><FONT face=3DArial =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Canada</SPAN></FONT></st1:country-region></st1:place><FONT=20
face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
FONT-FAMILY: Arial">,=20
V8N 1L6</SPAN></FONT> <BR><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Phone: (250)=20
477-8332</SPAN></FONT> <BR><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Email:=20
harvey@oromconsulting.com</SPAN></FONT> <BR><FONT face=3DArial=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">www.oromconsulting.com</SPAN></FONT>=20
<o:p></o:p></P>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
Joe Boyle [mailto:joeboyle_adt@hotmail.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, =
October 20, 2004=20
7:27 AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> =
'Harvey=20
Orom'<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Cc:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting =
rows in a=20
cluster</SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">At =
the risk=20
of stating the obvious, you can only use cursors with =
relational=20
databases. <O:P></O:P></SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><O:P></O:P>Which=20
file system are you using and which PH version and platform=20
?<O:P></O:P></SPAN></FONT><o:p></o:p></P>
<DIV>
<P><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><O:P></O:P>Regards,=20
Joe.</SPAN></FONT><o:p></o:p></P><O:P></O:P>
<P><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">This e-mail=20
and all information contained in it is confidential and may be =
legally=20
privileged. If you are not the intended</SPAN></FONT><FONT=20
color=3Dnavy><SPAN style=3D"COLOR: navy"> </SPAN></FONT><FONT =
face=3DArial=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">recipient,=20
your access to this e-mail is unauthorized. Any use, =
dissemination,=20
distribution, publication or copying by you of this e-mail or =
any of=20
the information contained within it is prohibited and may be =
unlawful.=20
Do not open any attachments, delete it immediately from your =
system=20
and notify the sender promptly by e-mail that you have done =
so. The=20
content of this e-mail and any attachments sent with it may =
have been=20
altered without the consent or knowledge of the=20
author.</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><FONT=20
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D3>
</SPAN></FONT></DIV>
<P class=3DMsoNormal><B><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
FONT-FAMILY: Tahoma">=20
powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com] <B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Harvey=20
Orom<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
20 October=20
2004 00:06<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">To:</SPAN></B>=20
Bickel, Jon<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">Cc:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting =
rows in a=20
cluster</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial"><O:P></O:P>Unfortunately,=20
I get the reference file from the primary file. I know I could =
use a=20
view, with temp fields in the cluster, and a loop to put =
a=20
designer file. I am just trolling for a more elegant =
solution.=20
Someone suggested a cursor - what do you think of=20
that?</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<P><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Cheers ...=20
<ST1:CITY u1:st=3D"on"><ST1:PLACE u1:st=3D"on"><st1:City=20
w:st=3D"on"><st1:place=20
=
w:st=3D"on">Harvey</st1:place></st1:City></ST1:PLACE></ST1:CITY></SPAN></=
FONT><O:P></O:P><o:p></o:p></P>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original =
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com]<B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Bickel,=20
Jon<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
Tuesday,=20
October 19, 2004 3:21 PM<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting =
rows in a=20
cluster</SPAN></FONT><O:P></O:P><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><ST1:CITY u1:st=3D"on"><ST1:PLACE=20
u1:st=3D"on"><st1:City w:st=3D"on"><st1:place =
w:st=3D"on"><FONT face=3DArial=20
color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Harvey</SPAN></FONT></st1:place></st1:City></ST1:PLACE></ST1:CITY>=
<FONT=20
face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">,</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial"><O:P></O:P>Is=20
it possible to get the reference file first and then =
retrieve=20
the primary, or is the retrieval of the reference file =
based on=20
a value from the=20
primary?</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial"><O:P></O:P>jb</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">From:</SPAN></B> Harvey Orom=20
[mailto:harvey@oromconsulting.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, =
October 19,=20
2004 5:01 PM<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">To:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> Sorting =
rows in a=20
cluster</SPAN></FONT><O:P></O:P><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is there any =
way to=20
present the rows in a cluster in a PowerHouse =
Quick=20
screen in a sequence by a column that is not in the =
primary file=20
(I.e., the column I want to sort by comes from a =
reference=20
file.) The primary file is being updated in this=20
screen.</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><O:P></O:P>Thanks in=20
advance...</SPAN></FONT><O:P></O:P><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Arial Black" =
color=3Dnavy=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: 'Arial =
Black'"><O:P></O:P>Harvey=20
Orom</SPAN></FONT>=20
=
<O:P></O:P><o:p></o:p></P></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></=
BLOCKQUOTE></BLOCKQUOTE></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><O:P></O:P> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> </SPAN></FONT><FONT=20
face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">This=20
message may contain privileged and/or confidential =
information. If you=20
have received this e-mail in error or are not the intended =
recipient, you=20
may not use, copy, disseminate or distribute it; do not open any=20
attachments, delete it immediately from your system and notify the =
sender=20
promptly by e-mail that you have done so. Thank =
you.</SPAN></FONT>=20
<o:p></o:p></P></DIV></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0030_01C4B6A0.29399A40--