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 displayed under a connection in the Data Source Explorer.
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.
To
create a new version of a DB2 for z/OS native SQL stored procedure
from the Data Source Explorer:
- Switch to the Data perspective.
- In the Data Source Explorer, right-click a native SQL stored
procedure in a DB2 for z/OS connection 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
Versions folder under the
original stored procedure, and the stored procedure opens in the routine
editor.