Create,execute and use the cursor

[abhinetri k]

Also please let me know if you have any idea of how to create and execute a dyanamic query in .qks file.
 
Thanks
Abhinetri
--- On Thu, 25/3/10, abhinetri k <abhinetri_cse at yahoo.co.in> wrote:


From: abhinetri k <abhinetri_cse at yahoo.co.in>
Subject: RE: Create,execute and use the cursor
To: "Peter Bateman" <peterbateman808 at hotmail.com>, powerh-l at lists.sowder.com
Date: Thursday, 25 March, 2010, 2:33 PM







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!.


      Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100325/8c8cffda/attachment.htm