---
title: "DB2-Stored Procedures – Examples"
description: "Complete resources on DB2 stored procedure s: http://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html. http://solutions.devx.com/ibm/skillbuilding/archives/walk..."
url: https://srinimf.com/2014/08/01/db2-stored-procedures/
date: 2014-08-01
modified: 2026-10-10
author: "Srini"
categories: ["DB2 V11"]
tags: ["DB2-Stored Procedures"]
type: post
lang: en
---

# DB2-Stored Procedures – Examples

[![The USA - New York City](https://i0.wp.com/srinimf.com/wp-content/uploads/2014/08/images.jpg?resize=284%2C177)](https://i0.wp.com/srinimf.com/wp-content/uploads/2014/08/images.jpg?ssl=1)*The USA – New York City*

**Complete resources on DB2 [stored procedure](https://srinimf.com/2016/06/19/3-steps-how-stored-procedure-works-in-db2/)s:**

1. [http://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html](http://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html)
2. [http://solutions.devx.com/ibm/skillbuilding/archives/walkthrough-creating-stored-procedures-in-db2.html](http://solutions.devx.com/ibm/skillbuilding/archives/walkthrough-creating-stored-procedures-in-db2.html)
3. [http://www.toadworld.com/platforms/ibmdb2/w/wiki/7467.creating-stored-procedures.aspx](http://www.toadworld.com/platforms/ibmdb2/w/wiki/7467.creating-stored-procedures.aspx)
4. [http://www.quest.com/quest_central_for_db2/pdfs/db2storedprocsandudfs.pdf](http://www.quest.com/quest_central_for_db2/pdfs/db2storedprocsandudfs.pdf)

There are two types of stored procedures:

- [External stored procedure](https://srinimf.com/2016/11/10/how-to-run-external-stored-procedure-in-db2-precise-idea/)s – It is written other than SQL language. For example C, JAVA. After compiling stored procedure we need to register it to DB2
- Internal Stored procedure –  It is written in SQL, and it is registered to DB2

In my next post I will give complete information on [how to](https://srinimf.com/2023/04/03/how-to-register-stored-procedures-in-a-db2-catalog-table/) write and execute external and Internal stored PROCs.

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2014%2F08%2F01%2Fdb2-stored-procedures%2F&media=http%3A%2F%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2014%2F08%2Fimages.jpg&description=DB2-Stored%20Procedures%20-%20Examples)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/08/01/db2-stored-procedures/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/08/01/db2-stored-procedures/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/08/01/db2-stored-procedures/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/08/01/db2-stored-procedures/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2-Stored%20Procedures%20-%20Examples&body=https%3A%2F%2Fsrinimf.com%2F2014%2F08%2F01%2Fdb2-stored-procedures%2F&share=email)
-

### Like this:

Like Loading…