<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi Abhinetri:<BR>
<BR>
By default Oracle temporary table rows are transaction based, i.e. they are cleared after a COMMIT.<BR>
<BR>
<A href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:48812348054">http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:48812348054</A><BR>
<BR>
If you use "on commit preserve rows" on the creation of the temporary table then the temportary data<BR>
survives a COMMIT but is not viewable to new session. If you are using PowerHouse OPEN numbers with Oracle<BR>
you get a new session with each distinct open number. <BR>
<BR>
The following reference again is version 8.4x.y<BR>
<FONT size=1><BR>
<A href="http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerhouse/8.4g/PHRDB.pdf">http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerhouse/8.4g/PHRDB.pdf</A> <BR>
<BR>
<BR>
You may want to use the Quick Debugger to trace the values going into the stored procedure.<BR>
<BR>
<BR>
Regards,<BR>
<BR>
Peter<BR></FONT>
<BR>
<BR><BR> <BR>
<HR id=stopSpelling>
Date: Thu, 25 Mar 2010 14:33:57 +0530<BR>From: abhinetri_cse@yahoo.co.in<BR>Subject: RE: Create,execute and use the cursor<BR>To: peterbateman808@hotmail.com; powerh-l@lists.sowder.com<BR><BR>
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD vAlign=top>
<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="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><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=ecxyiv489492293>
<STYLE>
.ExternalClass #ecxyiv489492293 .ecxhmmessage P
{padding:0px;}
.ExternalClass #ecxyiv489492293 .ecxhmmessage
{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=ecxstopSpelling>
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 border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD style="FONT-FAMILY: 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/" rel=nofollow>See your Yahoo! Homepage</A>. <BR>
<HR>
Take your contacts everywhere. <A href="http://go.microsoft.com/?linkid=9712958" rel=nofollow>Try Messenger for mobile</A> </DIV></BLOCKQUOTE></TD></TR></TBODY></TABLE><BR>
<HR SIZE=1>
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/">Get it NOW!</A>. <br /><hr />Stay in touch. <a href='http://go.microsoft.com/?linkid=9712959' target='_new'>Get Messenger on your phone now.</a></body>
</html>