New Package Variation wizard

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.

Feedback