DB2: What’s Stored Procedure

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 statement. It is a compiled program that is stored at a DB2 server, and can execute SQL statements. Stored procedures 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.

Two types of Stored procedures

  1. internal stored procedures – written in SQL
  2. external stored procedures – written in COBOL, PL/I, C,C++,JAVA, Assembler and REXX

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.