QMF provides a stored procedure development environment through the DB2 QMF High Performance Option (HPO) feature. For more information, see Appendix C. The DB2 QMF High Performance Option.
The IBM Redbook, Cross-Platform DB2 Stored Procedures: Building and Debugging, is another good source to learn how to build stored procedures. This Redbook covers three methods that can be used to develop stored procedures including using the Stored Procedure Builder, which is recommended if you do not use the DB2 QMF High Performance Option (HPO).