SEO

#1 (**permalink**) 02-27-2008, 11:48 AM

Hi.
I understand that static recursive stored procedure calls is not
supported in v8 and instead the call to another SP needs to be made
using dynamic SQL. Could anyone please let me know if there is any
performance difference between both of the above methods.
Thanks a lot.

#2 (**permalink**) 02-27-2008, 11:48 AM

Jo wrote:
> Hi.
> I understand that static recursive stored procedure calls is not
> supported in v8 and instead the call to another SP needs to be made
> using dynamic SQL. Could anyone please let me know if there is any
> performance difference between both of the above methods.
> Thanks a lot.
>
As long as you use parameter markers for the CALL arguments it won't matter.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#3 (**permalink**) 02-27-2008, 11:48 AM

Jo wrote:

> Hi.
> I understand that static recursive stored procedure calls is not
> supported in v8 and instead the call to another SP needs to be made
> using dynamic SQL. Could anyone please let me know if there is any
> performance difference between both of the above methods.

You don't need to call /another/ procedure. An SP can call itself using
dynamic SQL.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

dynamic SQL performance