Page 1 of 1
Re: What is the difference DB2 Store Procedure and native SQ
Posted: Wed May 20, 2015 2:15 pm
by nicc
They are talking about it, why not ask them? Did you Google the two phrases?
Re: What is the difference DB2 Store Procedure and native SQ
Posted: Fri May 22, 2015 2:47 pm
by Tahir Zaid
I am not sure what should i take away from your post. Google is there and provides answers to many things but that does not mean companies won't work or people will not ask question. It's a dedicated forum that's why I have asked.
I did my reserach before posting but it revealed that both are nearly similar and does similar things for a programmer. I am trying to understand more in detail about it.
Re: What is the difference DB2 Store Procedure and native SQ
Posted: Fri May 22, 2015 3:13 pm
by enrico-sorichetti
why waste time googling, faster to ask on a forum.
I hope that the title is just misleading...
and that the TS knows the difference between stored procedures and native SQL
as far as
native stored prodedures , googling exactly with the bolded words
returned as first link ( Your mileage might be different )
http://ibmdatamag.com/2012/08/db2-nativ ... computing/
with a good explanation of it
anyway the buzzwords are ...
Unlike external stored procedures, native stored procedures do not execute in a WLM address space. WLM is only required for debugging.
With Native SQL procedures, everything runs under the caller’s task. When the stored procedure is called, the caller’s DB2 thread simply switches to the SQL procedures package—no queuing, no delays, and less dispatch overhead.
I will let the TS investigate further !
and... there are always the IBM Redbooks to meditate on