Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Stored procedures

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
swatheeswaran

New User


Joined: 04 Nov 2008
Posts: 7
Location: Chennai

PostPosted: Tue Sep 29, 2009 11:07 pm    Post subject: Stored procedures
Reply with quote

What is the difference b/w internal and external stored procedures?
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Wed Sep 30, 2009 1:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
swatheeswaran

New User


Joined: 04 Nov 2008
Posts: 7
Location: Chennai

PostPosted: Wed Sep 30, 2009 10:27 pm    Post subject: When do we go for internal and When do we go for external?
Reply with quote

When do we go for internal and When do we go for external?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Oct 01, 2009 1:28 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Oct 01, 2009 2:54 pm    Post subject: Re: When do we go for internal and When do we go for externa
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm
This topic is locked: you cannot edit posts or make replies. Stored procedure on Federated thru DB2 arif677 DB2 6 Tue May 31, 2016 11:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us