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.
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.
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.