Create,execute and use the cursor

[Peter Bateman]

Hi Abhinetri:

 

    By default Oracle temporary table rows are transaction based, i.e. they are cleared after a COMMIT.

 

    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:48812348054

 

   If you use "on commit preserve rows" on the  creation of the temporary table  then the temportary data

   survives a COMMIT but is not viewable to new session. If you are using PowerHouse OPEN numbers with Oracle

   you get a new session with each distinct open number. 

 

   The following reference again is version 8.4x.y

   

 http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerhouse/8.4g/PHRDB.pdf   

 

 

    You may want to use the Quick Debugger to trace the values going into the stored procedure.

 

 

Regards,

 

Peter

 



 


Date: Thu, 25 Mar 2010 14:33:57 +0530
From: abhinetri_cse at yahoo.co.in
Subject: RE: Create,execute and use the cursor
To: peterbateman808 at hotmail.com; powerh-l at lists.sowder.com






Thanks Peter  - I do not have any manual on 8.13.D.
 
Please let me know if you have any idea on the below case as why it is happening 
 
I have created a pl/sql procedure to populate a temp table based upon the input text entered at the qks screen
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.
 
 
Regards
Abhinetri
 


--- On Thu, 25/3/10, Peter Bateman <peterbateman808 at hotmail.com> wrote:


From: Peter Bateman <peterbateman808 at hotmail.com>
Subject: RE: Create,execute and use the cursor
To: abhinetri_cse at yahoo.co.in
Date: Thursday, 25 March, 2010, 4:51 AM




Hi Abhinetri


Your version of PowerHouse is very old. Do you have the reference manual for PH8.13.D?

The following is a link to the 8.4x.y manuals.
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/powerhouse/8.4e/qdesign_reference.pdf

Check out DECLARE CURSOR statement

Essentially a cursor can be treated like a file in QDESIGN. Qdesign will generate statements
like open cursor, fetch, etc.

if a cursor is your primary source of data for a screen
you say something like:-

SQL in D_ORDERS declare xyz cursor for select c1, c2, c3, c4, c5  from ORDER_TABLES


Cursor xyz primary key { list of columns that make a unique combination }

Regards,
Peter
 


Date: Tue, 23 Mar 2010 16:05:27 +0530
From: abhinetri_cse at yahoo.co.in
Subject: Create,execute and use the cursor
To: powerh-l at lists.sowder.com






Hi All
 
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
 
Thanks In Advance.
 
Abhinetri.
 


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 


Take your contacts everywhere. Try Messenger for mobile 


Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. 		 	   		  
_________________________________________________________________
Take your contacts everywhere
http://go.microsoft.com/?linkid=9712959
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100326/b34de6a0/attachment.htm