Versioning DB2 for z/OS native SQL stored procedures

You can use the workbench to create a new version of a native SQL stored procedure for DB2® for z/OS®. You can create a new version from a data development project, or you can create a new version from the Database Explorer. This function is supported only for DB2 z/OS 9 or higher.

A new version of a native SQL stored procedure has the same schema, name, parameter count, and parameter data types (in the same order) as the original, but has a different version ID. It can also have different options and a different body. After you create a version of a stored procedure, you can perform any action on the stored procedure version that you can perform on any other stored procedure. For example, you can deploy the stored procedure version, run it, or debug it.


Feedback