What is the difference DB2 Store Procedure and native SQL

[nicc]

They are talking about it, why not ask them? Did you Google the two phrases?

[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.

[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