dynamic SQL performance

[Jo]

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.

[Serge Rielau]

Re: dynamic SQL performance

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

[Knut Stolze]

Re: dynamic SQL performance

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