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.
Before you begin
You must create a data development project.
About this task
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.
Procedure
To create a new version of a DB2 for z/OS native
SQL stored procedure from the Data Project Explorer:
- 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.
- Complete the steps of the wizard.
- Click Finish.
Results
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.