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 Database Explorer.
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
Database Explorer:
- Switch to the Data perspective.
- In the Database 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.
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.