What is the difference DB2 Store Procedure and native SQL

RDBMS from IBM.
Previous topicNext topic

Topic Author
nicc
Global Moderator
Global Moderator
Posts: 597
Joined: Wed Apr 23, 2014 8:45 pm

Re: What is the difference DB2 Store Procedure and native SQ

Post by nicc » Wed May 20, 2015 2:15 pm

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


Regards
Nic


Tahir Zaid
New Member
Posts: 1
Joined: Sun Sep 14, 2014 9:33 pm

Re: What is the difference DB2 Store Procedure and native SQ

Post by Tahir Zaid » Fri May 22, 2015 2:47 pm

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
Global Moderator
Global Moderator
Posts: 891
Joined: Wed Sep 11, 2013 3:57 pm

Re: What is the difference DB2 Store Procedure and native SQ

Post by enrico-sorichetti » Fri May 22, 2015 3:13 pm

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


cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)

Previous topicNext topic

Return to “IBM DB2.”