dbTalk Databases Forums  

Extract cursor(result set) from SQL PL Stored procedure

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Extract cursor(result set) from SQL PL Stored procedure in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Arun Srini
 
Posts: n/a

Default Extract cursor(result set) from SQL PL Stored procedure - 06-04-2010 , 08:55 AM






Hi
I need to get a resultset and pipe it to a file in linux. I thought
this should just involve opening a cursor and having DYNAMIC RESULT
SETS 1 statement, opening the cursor and just leaving it like that,
and I'd be getting result sets just like I get when I run load command
using admin_cmd procedure. I was wrong,
I didn't get any, just the output variable. All I could find was how
to recieve the cursors as result sets in other program or routine, not
how to get them as outputs.

Please help.
Arun

Reply With Quote
  #2  
Old   
Arun Srini
 
Posts: n/a

Default Re: Extract cursor(result set) from SQL PL Stored procedure - 06-04-2010 , 09:01 AM






On Jun 4, 6:55*pm, Arun Srini <arunro... (AT) gmail (DOT) com> wrote:
Quote:
Hi
I need to get a resultset and pipe it to a file in linux. I thought
this should just involve opening a cursor and having DYNAMIC RESULT
SETS 1 statement, opening the cursor and just leaving it like that,
and I'd be getting result sets just like I get when I run load command
using admin_cmd procedure. I was wrong,
*I didn't get any, just the output variable. All I could find was how
to recieve the cursors as result sets in other program or routine, not
how to get them as outputs.

Please help.
Arun
sorry my bad, didn't include the 'with return for' in the cursor
declaration.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.