<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV><FONT color=#0000bf>Thanks Peter - I do not have any manual on 8.13.D.</FONT></DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf>Please let me know if you have any idea on the below case as why it is happening </FONT></DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf>I have created a pl/sql procedure to populate a temp table based upon the input text entered at the qks screen</FONT></DIV>
<DIV><FONT color=#0000bf>When I execute the procedure from TOAD ,the temp table gets populated,but when I execute it from powerhouse (i.e I called the procedure in find procedure of .qks file)the table is not getting populated.</FONT></DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf>Regards</FONT></DIV>
<DIV><FONT color=#0000bf>Abhinetri</FONT></DIV>
<DIV> </DIV>
<DIV><BR><BR>--- On <B>Thu, 25/3/10, Peter Bateman <I><peterbateman808@hotmail.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><BR>From: Peter Bateman <peterbateman808@hotmail.com><BR>Subject: RE: Create,execute and use the cursor<BR>To: abhinetri_cse@yahoo.co.in<BR>Date: Thursday, 25 March, 2010, 4:51 AM<BR><BR>
<DIV id=yiv489492293>
<STYLE><!--
#yiv489492293 .hmmessage P
{
margin:0px;padding:0px;}
#yiv489492293 .hmmessage
{
font-size:10pt;font-family:Verdana;}
--></STYLE>
Hi Abhinetri<BR><BR><BR>Your version of PowerHouse is very old. Do you have the reference manual for PH8.13.D?<BR><BR>The following is a link to the 8.4x.y manuals.<BR>http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerhouse/8.4e/qdesign_reference.pdf<BR><BR>Check out DECLARE CURSOR statement<BR><BR>Essentially a cursor can be treated like a file in QDESIGN. Qdesign will generate statements<BR>like open cursor, fetch, etc.<BR><BR>if a cursor is your primary source of data for a screen<BR>you say something like:-<BR><BR>SQL in D_ORDERS declare xyz cursor for select c1, c2, c3, c4, c5 from ORDER_TABLES<BR><BR><BR>Cursor xyz primary key { list of columns that make a unique combination }<BR><BR>Regards,<BR>Peter<BR> <BR>
<HR id=stopSpelling>
Date: Tue, 23 Mar 2010 16:05:27 +0530<BR>From: abhinetri_cse@yahoo.co.in<BR>Subject: Create,execute and use the cursor<BR>To: powerh-l@lists.sowder.com<BR><BR>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD style="FONT-FAMILY: inherit; font-size-adjust: inherit; font-stretch: inherit" vAlign=top>
<DIV>Hi All</DIV>
<DIV> </DIV>
<DIV>Please let me know how to declare ,execute a cursor and display the result set of cursor in .qks file i.e QDESIGN .The powerhouse version I use in 8.13.D</DIV>
<DIV> </DIV>
<DIV>Thanks In Advance.</DIV>
<DIV> </DIV>
<DIV>Abhinetri.</DIV>
<DIV> </DIV></TD></TR></TBODY></TABLE><BR>
<HR SIZE=1>
The INTERNET now has a personality. YOURS! <A href="http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/" target=_blank rel=nofollow>See your Yahoo! Homepage</A>. <BR>
<HR>
Take your contacts everywhere. <A href="http://go.microsoft.com/?linkid=9712958" target=_blank rel=nofollow>Try Messenger for mobile</A> </DIV></BLOCKQUOTE></td></tr></table><br>
<!--1--><hr size=1></hr>
Your Mail works best with the New Yahoo Optimized IE8. <a href="http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/" target="_blank">Get it NOW!</a>.