Complete resources on DB2 stored procedures:
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.