Creating a new version of a DB2 for z/OS native SQL stored procedure from the Data Project Explorer

You can use the New Version wizard to create a new version of a native SQL stored procedure that targets DB2® z/OS® 9 that is stored in a data development project in the Data Project Explorer.
Prerequisite: You must create a data development project.

Using the New Version wizard, you specify a unique version ID and options for the new stored procedure version. Some fields in the wizard are read-only. When you create a new version of a stored procedure, you can specify different build and deploy options, and you can specify whether to enable debugging. All other properties of the stored procedure, including parameters and error handling, cannot be modified from the original version in the wizard.

To create a new version of a DB2 for z/OS native SQL stored procedure from the Data Project Explorer:

  1. Switch to the Data perspective.
  2. In the Data Project Explorer, right-click a native SQL stored procedure in a data development project and click New Version. The New Version wizard opens.
  3. Complete the steps of the wizard.
  4. Click Finish.
The wizard creates the new version of the stored procedure and adds it to the Stored Procedures folder in the project, and the stored procedure opens in the routine editor.

Feedback