|
View previous topic :: View next topic
|
| Author |
Message |
anu2
Warnings : 1
New User
Joined: 10 Jun 2007
Posts: 36
Location: Chennai
|
|
|
|
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 |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
anu2
Warnings : 1
New User
Joined: 10 Jun 2007
Posts: 36
Location: Chennai
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| 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 |
|
|
anu2
Warnings : 1
New User
Joined: 10 Jun 2007
Posts: 36
Location: Chennai
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| It works for me. I told you, wait.......or you don't have a JAVA VRE installed on your pc. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| the manuals link at the top of this page has links to DB2 V8. Use those links. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
|
|
