DB2-Stored Procedures – Examples

The USA - New York City
The USA – New York City

Complete resources on DB2 stored procedures:

  1. 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
  3. 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

There are two types of stored procedures:

  • External stored procedures – 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 write and execute external and Internal stored PROCs.

Author: Srini

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