By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

dynamic SQL performance

P: n/a
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.

Feb 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Feb 22 '07 #2

P: n/a
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
Feb 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.