Complete resources on DB2 stored procedures:
- http://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html
- http://solutions.devx.com/ibm/skillbuilding/archives/walkthrough-creating-stored-procedures-in-db2.html
- http://www.toadworld.com/platforms/ibmdb2/w/wiki/7467.creating-stored-procedures.aspx
- 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.
You must be logged in to post a comment.