View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 11:48 AM
Knut Stolze
 
Posts: n/a
Default 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
Reply With Quote