Create,execute and use the cursor

[abhinetri k]

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 


      The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100325/79678496/attachment.htm