What is the difference DB2 Store Procedure and native SQL
Re: What is the difference DB2 Store Procedure and native SQ
They are talking about it, why not ask them? Did you Google the two phrases?
Regards
Nic
Nic
-
- New Member
- Posts: 1
- Joined: Sun Sep 14, 2014 9:33 pm
Re: What is the difference DB2 Store Procedure and native SQ
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.
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.
-
- Global Moderator
- Posts: 826
- Joined: Wed Sep 11, 2013 3:57 pm
Re: What is the difference DB2 Store Procedure and native SQ
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 ...
and... there are always the IBM Redbooks to meditate on
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 ...
I will let the TS investigate further !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.
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
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
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute