---
title: "DB2: What’s Stored Procedure"
description: "Today's post. What is stored procedure? How many types of stored procedures? What are those? A stored procedure  is a user-written program that can be called by an application with an SQL CALL stateme..."
url: https://srinimf.com/2016/01/23/db2-stored-procedures-in-10-days-part-1/
date: 2016-01-23
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2016/01/pexels-photo-1086711.jpeg?fit=1880%2C1253&ssl=1
categories: ["Mainframe DB2", "Stored procedures"]
tags: ["How many types of stored procedures in DB2"]
type: post
lang: en
---

# DB2: What’s Stored Procedure

**Today’s post**

- What is stored procedure?
- How many types of stored procedures?
- What are those?

A [stored procedure](http://www.indeed.com/jobs?q=Stored+Procedures&l=United+States&indpubnum=6634974704162507) is a user-written program that can be called by an application with an SQL CALL statement. It is a compiled program that is stored at a DB2 server, and can execute SQL statements. [Stored procedure](https://srinimf.com/2016/06/19/3-steps-how-stored-procedure-works-in-db2/)s can be called locally (on the same system where the application runs) and remotely (from a different system). However, stored procedures are particularly useful in a distributed environment.

Related[Logic to call COBOL program from stored Procedure](https://srinimf.com/2013/03/22/db2-calling-cobolcjava-programs-from-stored-proc/)

**[Two types of](https://srinimf.com/2022/01/23/two-types-of-plsql-cursors-what-are-those/) [Stored procedure](https://srinimf.com/2018/06/26/stored-procedures-vs-functions-top-differences-refresh-before-your-interview/)s**

1. internal stored procedures – written in SQL
2. external stored procedures – written in COBOL, PL/I, C,C++,[JAVA](http://www.indeed.com/jobs?q=java&l=United+States&indpubnum=6634974704162507), Assembler and REXX

Related Posts

- [Internal Process How Stored Procedure Executes](https://srinimf.com/2016/06/19/3-steps-how-stored-procedure-works-in-db2/)DateJune 19, 2016
- [DB2: How to Call External Stored procedure](https://srinimf.com/2016/11/10/how-to-run-external-stored-procedure-in-db2-precise-idea/)DateNovember 10, 2016
- [How to Access Stored procedure in CICS popular example to invoke it](https://srinimf.com/2013/03/25/db2-stored-proc-from-cics-how/)DateMarch 25, 2013

### 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%2F2016%2F01%2F23%2Fdb2-stored-procedures-in-10-days-part-1%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2016%2F01%2Fpexels-photo-1086711.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=DB2%3A%20What%27s%20Stored%20Procedure)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2016/01/23/db2-stored-procedures-in-10-days-part-1/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2016/01/23/db2-stored-procedures-in-10-days-part-1/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2016/01/23/db2-stored-procedures-in-10-days-part-1/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2016/01/23/db2-stored-procedures-in-10-days-part-1/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%3A%20What%27s%20Stored%20Procedure&body=https%3A%2F%2Fsrinimf.com%2F2016%2F01%2F23%2Fdb2-stored-procedures-in-10-days-part-1%2F&share=email)
-

### Like this:

Like Loading…