How useful is to use Db2 Stored Procedures for z/OS?.
I don't know yet. First, we know there are two types of Stored Procedures: Internal and External. Internal Stored Procedures are written in SQL PL and run in DBM1 Address Space whereas External Stored Procedures are written in a high level language like Cobol, C, or JAVA and run in a WorkLoad Manager for Stored Procedures. Both Internal and external need to be declared with the Create DDL Sentence and both are defined in the Db2 Catalog. So, I am right now going deep in the use of Db2 Stored Procedures, coding and testing in my Job's Mainframe. My goal is to improve the performance and to expose the Mainframe assets in a centralized way. In our data center we have the banking core systems in a z15 and the systems of engagement in an Azure Cloud. So this apps outside the Mainframe need to access to data in Db2 Tables and VSAM files. Welcome your feedback and comments about this.