<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:ns0 =
"http://www.exclaimer.co.uk"><HEAD><TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2180" 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><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></BODY></HTML>