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.
- Collection ID
- Shows the collection ID that was specified for the source package.
- Package ID
- Shows the package name for the stored procedure.
- Version ID
- Shows the version ID used in the COPYVER option for the BIND COPY statement,
or shows an empty string if no version ID was specified.
- Target Location Options
- Location
- Specify the database name of the remote server, used for doing a BIND
COPY remotely. You can click Connection to open a window
so that you can either create a new connection or select an existing connection.
- Collection ID
- Browse to an available collection ID on the server. The browser window
will not show the source collection ID.
- Bind Options
- Type a string that specifies bind options for the package variation. These
options are used with the BIND COPY statement. The default options are ACTION(REPLACE)
and ISOLATION(CS). ACTION(REPLACE) specifies that the package replaces an
existing package with the same name. ISOLATION(CS) ensures that your application
does not read a row that another process changes until that process releases
the row.