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.