<HTML xmlns:eXclaimer="http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16"><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR><!--[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]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@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 {
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-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD><BODY lang=EN-US vLink=purple link=blue><DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT
size=2>Fernando,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT size=2>I believe
the answer to your questions is Yes and Yes...with PowerHouse 8 you can do
either -- embed a declared cursor in your PH code, or create a view or stored
procedure in the database and have PH access that. You can find all the details
in the PowerHouse Series 8 Books, available online from the PowerHouse
site...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT color=#000000
size=2><A
href="http://powerhouse.cognos.com/products/powerhouse/download.html">http://powerhouse.cognos.com/products/powerhouse/download.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT size=2>The one you
really need to take a look at is the <EM>PowerHouse and Relational
Databases</EM> book...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=597085223-11082005><FONT color=#000000
size=2><A
href="http://powerhouse.cognos.com/products/powerhouse/downloads/PH_and_Relational_Databases.pdf">http://powerhouse.cognos.com/products/powerhouse/downloads/PH_and_Relational_Databases.pdf</A></FONT></SPAN></DIV>
<DIV><SPAN lang=en-us><FONT face=Tahoma size=2><SPAN lang=en-us><FONT
face=Tahoma size=2></FONT></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN lang=en-us><FONT face=Tahoma size=2><SPAN lang=en-us><FONT
face=Tahoma size=2>Best regards,</FONT></SPAN><BR><SPAN lang=en-us><B><I><FONT
face="Times New Roman" color=#000080 size=6>Conrad</FONT></I></B></SPAN> </DIV>
<P><SPAN lang=en-us><FONT face=Tahoma color=#808080 size=1>Conrad
Whittall</FONT></SPAN><BR><SPAN lang=en-us><FONT face=Tahoma color=#808080
size=1>Senior Solutions Architect, Global Customer Services, Cognos
Incorporated</FONT></SPAN><BR><SPAN lang=en-us><FONT face=Tahoma color=#808080
size=1>3755 Riverside Drive, Ottawa, Ontario, K1G 4K9,
Canada</FONT></SPAN></P></FONT></SPAN><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+conrad.whittall=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+conrad.whittall=cognos.com@lists.sowder.com] <B>On
Behalf Of </B>fernando.olmos@hpa.com.au<BR><B>Sent:</B> Thursday 11 August 2005
18:51<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Indexed or
Seq?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Fernando Olmos
<BR><B>Sent:</B> Friday, August 12, 2005 8:24 AM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Indexed or
Seq?<BR><BR></FONT></DIV>
<DIV><SPAN class=155472022-11082005><FONT face=Arial color=#0000ff size=2>Bob
and Joe,</FONT></SPAN></DIV>
<DIV><SPAN class=155472022-11082005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=155472022-11082005><FONT face=Arial color=#0000ff
size=2>Thank you both for the input. I fully understand what's going on. Just
one more question... Bob, are you saying to declare the cursor using SQL or is
there a way to do this in QUIZ and have it embedded into the BUILD of the QUIZ
program? OR can the cursor be declared at the database level and accessed via
QUIZ? A view? Sorry, but I am not that familiar with Oracle. I know in Oracle
RDB, from the VAX, we were able to "stream-line" queries with cursors, but
only using embedded SQL within COBOL. I have never seen cursors been used from
within Powerhouse.</FONT></SPAN></DIV>
<DIV><SPAN class=155472022-11082005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=155472022-11082005><FONT face=Arial color=#0000ff
size=2>Cheers</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
Bob.Deskin@Cognos.COM [mailto:Bob.Deskin@Cognos.COM] <BR><B>Sent:</B>
Friday, August 12, 2005 4:57 AM<BR><B>To:</B> atla38@dsl.pipex.com; Fernando
Olmos; powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Indexed or
Seq?<BR><BR></FONT></DIV>
<DIV><SPAN class=265175618-11082005><FONT face=Arial color=#0000ff
size=2><SPAN
class=767145122-11082005>[F.Olmos] <snip> </SPAN></FONT></SPAN></DIV></BLOCKQUOTE></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> <FONT FACE="Arial" SIZE="2">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>
</DIV>
<DIV>
<P>
<FONT FACE="Arial" SIZE="2"> </FONT>
</P>
</DIV></BODY></HTML>