Here are the tips on how to write a Stored procedure in DB2 correctly. These slides show you all the ideas one by one.
DB2 Tough Interview Questions
Useful for Interviews and Projects.
Here are the writing tips for Stored procedures. Easy maintenance is the prime purpose to follow some standards.
How to Write Stored Procedures (Slide Share)