Here are steps of how to create a procedure in SQL developer and how to call it.
Category: SQL Stored Procedures
The best example for Java stored procedure in DB2, also given java class path to write stored procedure and explained how to include it in the DB2 stored procedure standard block. Read more.
The Associate cursor in DB2 is being used in Stored procedure. The purpose is while calling a Stored procedure from an another stored procedure this Associate acts as to hold result set.
Srinimf 