|
View previous topic :: View next topic
|
| Author |
Message |
swatheeswaran
New User
Joined: 04 Nov 2008
Posts: 7
Location: Chennai
|
|
|
|
| What is the difference b/w internal and external stored procedures? |
|
| Back to top |
|
 |
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
euhm, that external are located outside DB2 and internal inside ?
External stored procedures : Programs (in cobol,rexx, C,...) that are compiled and the loadmodule is in some loadlib and the dbrm in another.
dbrms are bound to packages.
The external name (of the loadmodule) is given during the create stored procedure.
At runtime the loadlibs are searched for the correct loadmodule.
Internal : SQL native procedures:
The source is given during the Create stored procedure.
All executable code is in the package. no outside compiler,loadlib,... is needed. |
|
| Back to top |
|
|
swatheeswaran
New User
Joined: 04 Nov 2008
Posts: 7
Location: Chennai
|
|
|
|
| When do we go for internal and When do we go for external? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
no need for bold, my eyesight is fine,I'm not that old.
It depends on the language you want to / can program.
Internal SQL native is a little bit more performant, but limited in its possibilities. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| swatheeswaran wrote: |
| When do we go for internal and When do we go for external? |
Are you annoyed to someone (GuyC? We'll request him not to answer your queries, if so). On these Forum CAPS or bold are considered as shouting, please avoid their use unless you're left with no choice.
When do we go for what depnds on your requirement, as name Implies the code for external stored procedure is stored outside the database. And multiple threads can call and reuse the same stored procedure by defining as reentrant.
I'm not sure, why you used the term "Internal" -- I've been using the phrase "SQL Procedures". Did you mean the same? |
|
| Back to top |
|
|
|
|
