Rational Developer for System z

Building a stored procedure

This is the process for building a stored procedure.

Before you begin

Before a stored procedure can be invoked from the Database Explorer view or any other calling program, it must be built on the remote system.

Procedure

  1. Right-click the stored procedure in the Data Project Explorer and select Build. The build utility is now invoked on the remote system and builds the executable form of the stored procedure. This process includes the compilation of the source code, the linkage of the load module, the binding of the DB2® package and the registration of the stored procedure in the DB2 catalog.

    The build process is displayed in the Data Output tab with the status “In progress” until it is completed.

    The status in the Data Output tab changes to "Success" or "Failure" when the build process is completed. When execution is successful, a short summary of the build process is displayed.

    If the build process was not successful, information about the failure will be displayed in the Data Output tab.

  2. Once the stored procedure has been built on the remote system and refreshed, it will appear in the Database Explorer view. To refresh, right-click on the Stored Procedures folder in the Database Explorer view and select Refresh. Wait until the refresh has been completed. The stored procedure will appear in the Stored Procedures folder of the Database Explorer view after the connection has been refreshed.

What to do next


Feedback