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
 

 

External and Internal Stored Procedures

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

New User


Joined: 10 Jun 2007
Posts: 36
Location: Chennai

PostPosted: Sun Aug 19, 2007 8:33 pm    Post subject: External and Internal Stored Procedures
Reply with quote

Hi,

Could anyone let me know the difference between External and Internal Stored Procedures and how they are used ?

Will be greatful if one can provide an example with a piece of code.


Regards,
anu
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Aug 20, 2007 1:38 am    Post subject: Reply to: External and Internal Stored Procedures
Reply with quote

well there is no such thing in IBM speak as an internal stored procedure.

Quote:

You can create one of the following types of stored procedures:

SQL procedures The procedure is written exclusively in SQL statements. The body of an SQL procedure is written in the SQL procedural language. SQL procedures can be either external SQL procedures or native SQL procedures. For more information about these types of SQL procedures, see “SQL procedures” on page 714.
External stored procedures External stored procedures are written in a host language. The source code for an external stored procedure is separate from the definition for the stored procedure. For more information about external stored procedures, see “External stored procedures” on page 757.


the pages that are referenced are in the DB2 Version 9.1 for z/OS Application Programming and SQL Guide.

If you want examples, look in the manuals. There is also a samples library on your mainframe called SYS1.DB2V8R1.DSNSAMP (or something similar, your are probably be better off looking for *.*.DSNSAMP) which is a sample library (PDS) that ships with DB2.
Back to top
View user's profile Send private message
anu2
Warnings : 1

New User


Joined: 10 Jun 2007
Posts: 36
Location: Chennai

PostPosted: Mon Aug 20, 2007 12:14 pm    Post subject: SQL Guide
Reply with quote

Thanks for the response.

Could you please let me know where i can get the link for DB2 Version 9.1 for z/OS Application Programming and SQL Guide ?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Aug 20, 2007 12:28 pm    Post subject:
Reply with quote

Here is a link to DB2 V8 z/OS, V9.1 z/OS, QMF, and IMS. Give it a couple seconds to load. Don't be discouraged with the little blurg about being a bad link, give it about 10 seconds and everything will load. There are probably better links, but this one will give you all the products.
Back to top
View user's profile Send private message
anu2
Warnings : 1

New User


Joined: 10 Jun 2007
Posts: 36
Location: Chennai

PostPosted: Tue Aug 21, 2007 3:43 pm    Post subject: Link
Reply with quote

This link still says---

The topic that you have requested is not available. The link may be wrong, or you may not have the corresponding product feature installed. This online help only includes documentation for features that are installed.



Please give me some other link .
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 21, 2007 4:06 pm    Post subject:
Reply with quote

It works for me. I told you, wait.......or you don't have a JAVA VRE installed on your pc.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 21, 2007 4:15 pm    Post subject:
Reply with quote

the manuals link at the top of this page has links to DB2 V8. Use those links.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 21, 2007 4:28 pm    Post subject:
Reply with quote

or use this link http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/library

and enter DB2. You can get all documents for DB2 up to and including V8.

Here is a link for DB2 for z/OS- Vsns 7, 8 and 9.
http://www-306.ibm.com/software/data/db2/zos/library.html
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 Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
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 6 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


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