Re: How to use fetch while calling sql stored procedure in rpg ?

Not if you are not in the RPG list

;-)

-------------- Original message -------------- 
From: rob@xxxxxxxxx 

> Do people just ignore questions if they didn't ask them? This exact 
> question was asked just last week. 
> 
> http://archive.midrange.com/rpg400-l/200602/msg00486.html 
> http://archive.midrange.com/rpg400-l/200602/msg00534.html 
> 
> 
> Rob Berendt 
> -- 
> Group Dekko Services, LLC 
> Dept 01.073 
> PO Box 2000 
> Dock 108 
> 6928N 400E 
> Kendallville, IN 46755 
> http://www.dekko.com 
> 
> 
> 
> 
> 
> "Luqman" 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> 03/02/2006 04:00 AM 
> Please respond to 
> Midrange Systems Technical Discussion 
> 
> 
> To 
> midrange-l@xxxxxxxxxxxx 
> cc 
> 
> Fax to 
> 
> Subject 
> How to use fetch while calling sql stored procedure in rpg ? 
> 
> 
> 
> 
> 
> 
> How can I retrieve results from Stored Procedure while using it in RPG ? 
> 
> say :- I called a sql stored procedure MYPROC in my SQLRPGLE Program. 
> 
> 
> C/EXEC SQL 
> C+ CALL MYPROC(:H1,:H2) 
> C/END-EXEC 
> 
> Now how can I display this result, as in case of cursor, we use" fetch 
> cursor name into variable name" 
> 
> Best Regards, 
> 
> Luqman 
> 
> 
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>