Creating a new variation of a SQL or SQLJ stored procedure package for DB2 for z/OS

You can use the New Package Variation wizard to create a new variation of a SQL or SQLJ stored procedure package that targets DB2® for z/OS®.

Before you begin

Before you can create a new variation for a SQL or SQLJ stored procedure package, you must complete the following prerequisite steps:

About this task

Using the New Package Variation wizard, you specify options for a variation of an existing stored procedure package. You can specify a location for the package variation, a collection ID, and bind options.

Procedure

To create a new variation of a SQL or SQLJ stored procedure package for DB2 for z/OS:

  1. In the Data Source Explorer, right-click the Packages folder under a stored procedure in a DB2 for z/OS connection and click New. The New Package Variation wizard opens.
  2. Complete the steps of the wizard.
  3. Click Finish.

Results

The wizard creates the new package variation for the stored procedure and adds it to the Packages folder.

Feedback