Developing COBOL and PL/I Stored Procedures

The Developer for z/OS® product supports Db2® Stored Procedures for COBOL and PL/I.

Before you begin

You develop stored procedures for COBOL and PL/I in a data development project in using the z/OS Projects perspective. The information about developing stored procedures for COBOL and PL/I assumes that you are familiar with these concepts.

Note: A connection through the Remote Systems view to access data sets on the remote system. For more information about connecting to a remote system, see Connecting to a z/OS system.

Setting z/OS build options for a stored procedure
To prepare for writing stored procedures, you must set up your Property Groups. Each of these steps links to a task with detailed instructions. They must be completed in the order listed.
Deploying a stored procedure
Before you can run a stored procedure from the Data Project Explorer view or any other calling program, you must deploy it on the remote system.
Running a stored procedure
After a stored procedure is deployed on the remote system, it can be run from the Data Project Explorer view or the Data Source Explorer view.
Debugging a stored procedure
To debug a stored procedure, it must be built with specific compiler and runtime options.
Sample stored procedure
A sample stored procedure is provided for you. PL/I source code is provided for it. There is also a COBOL source code example if you want to create a sample stored procedure in COBOL.