Relational Database Management Systems (RDBMs):

Stored procedures written for DB2 are proprietary to DB2

• Subject Matter DBAs will provide expertise for stored procedures
•  The language a stored procedure is written in depends on the primary language used within the system. That is, if the application is mainly COBOL then use COBOL. Use PL-SQL for very simple cases.
•  All stored procedures for a given application should be in the same language unless they are being reused.
•  You should NOT use nested stored procedures.
•  They should only be used for data access and should not contain business logic.

Note:

Stored Procedures are a good fit when there are data access performance issues.

www.bestitdocuments.com